Pivot Tables - Percentages in Row, Column, & Grand Totals
Posted by David Schwartz on October 26, 2001 4:34 AM
I am having a problem with calculated percentages showing up correctly in the row, column and grand total section of my pivot table. Instead of my percentages being recalculated based on the totalled data, my cell percentages themselves are being summed. Example: spreadsheet has 3 column headings: month, sold, returned. Under the headings are two rows of data: ROW 1 is jan,10,5. ROW 2 is feb,10,3. When I do the pivot table I put "month" as a column and "sold" and "returned" in the middle. Then I create a calculated field with formula = returned/sold. Thus, for January, my cell shows 10, 5 and 50%. In my row totals, I get 20 sold and 8 returned - which is correct. My percentage calculations in the individual cells work just fine but in the pivot table row total, my percentage shows as 80% (50% for Jan plus 30% for Feb), instead of 40% (8/20). How do I get around this to have correct percentages in my column, row and grand totals?