Pivot table Calculations

[pivot table drop down values]

I added a formula to my rather large pivot table however when I refreshed it
it calculates & after a few minutes it eventually Excel closes.

I think the file is too large. Approx 8000 rows 20 columns