Hi
In my Pivot Table I pull data from 2 columns of a spreadsheet (Total Cost and Total Price) What I'm trying to do is have the Pivot table reflect the percentage difference but I keep getting #N/A as a result.
The spreadsheet also has a column for the percentage difference but when I include this column in the Pivot table it sums the percentages rather than giving me the acurate percentage for the grand total. I tried adding the Total price field twice and then making the second a "% of" with the Total Cost field as the Base but that just returns the #N/A eror. Anyone have any thoughts?
Thanks as always!!
In my Pivot Table I pull data from 2 columns of a spreadsheet (Total Cost and Total Price) What I'm trying to do is have the Pivot table reflect the percentage difference but I keep getting #N/A as a result.
The spreadsheet also has a column for the percentage difference but when I include this column in the Pivot table it sums the percentages rather than giving me the acurate percentage for the grand total. I tried adding the Total price field twice and then making the second a "% of" with the Total Cost field as the Base but that just returns the #N/A eror. Anyone have any thoughts?
Thanks as always!!