ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Grand total in Pivot-Table (https://www.excelbanter.com/excel-worksheet-functions/64119-grand-total-pivot-table.html)

TaiwanSwede

Grand total in Pivot-Table
 
I have a number of rows of data in a pivot table with subtotals and a grand
total. The subtotals are summarized by Average in "Field settings". For grand
total I would like to have a sum of all the subtotal averages.

However, when I choose to summarize by Average in "Field settings" the grand
total is the average of all the rows.

Is there any way I can change the grand total to be the sum of all the
subtotal averages.


All times are GMT +1. The time now is 11:27 AM.

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