ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculated percentage field in a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/193387-calculated-percentage-field-pivot-table.html)

scubadiver

Calculated percentage field in a pivot table
 

This is a part of the pivot table

Year Class average of subtot sum of accounts

2002 1 126631 18759
2 126631 19103
3 126631 59277
4 126631 24416
5 126631 5076


How can I insert a field to get the percentage? I have tried but I get the
wrong answer.

cheers!



All times are GMT +1. The time now is 11:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com