Percentages in Pivot Tables
 

I have two pivot tables in my worksheet - one is calculating the % value
correctly, one isn't. Basically the one that isn't is a pivot table
summarising data from three files. The % from the 'Grand Total' row is
actually adding up the percentage column, instead of dividing the two earlier
columns.
I don't think I am making myself too clear, but if there is someone who
thinks they could help me and wouldn't mind looking at my spreadsheet, I
would be really grateful as I am tearing my hair out!

Is the % column coming from your source data? If so, instead of using the
field from your source data, try inserting a calcuted field for the % column
directly into your pivot table.
Using the Pivot Table toolbar, go to Formulas--Calculated Field.

Create the calculation using the previous two columns. If I'm understanding
your question, this should work.

Jeff


"ajames" wrote:

I have two pivot tables in my worksheet - one is calculating the % value
correctly, one isn't. Basically the one that isn't is a pivot table
summarising data from three files. The % from the 'Grand Total' row is
actually adding up the percentage column, instead of dividing the two earlier
columns.
I don't think I am making myself too clear, but if there is someone who
thinks they could help me and wouldn't mind looking at my spreadsheet, I
would be really grateful as I am tearing my hair out!