I'm trying to enter a variance column to compare data from April versus May. I figured out how to calculate the data by using Pivot Table Tools > Options > Formulas > Calculated Item. However, after I enter the formula, I get a pop-up error that says "There are too many records to complete this operation."
The pivot table is 185 rows and the source table is 473 rows. It doesn't seem like the table is so large that Excel wouldn't be able to handle calculating the data. Any ideas on what could be going wrong?
-K
Bookmarks