G
Guest
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!
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!