Pivot Table Calculated Item Crashing Workbook

[MountainFog]

Hi All,

Thanks in advance for the help. I'm trying to create a pivot table and compare between two different sources, and have created calculated item: Formula 1 = Source1-Source2

I have the first pivot table that shows without the calculated item, and when I add it, it lists ever individual even if they aren't in the catagory.

This is causing quite an issue because the data set is significant, and crashes excel when I do it with the larger dataset.

 

[cooleomter]

Hi Sorry, i don't understand the goal for your pivot table and other formulas like formula 1 grand total.. Can you please tell me. your goal. Thank you.