Add calculation options to grand totals
It'd be great if we can have multiple calculation options to the grand total for rows and columns. In other words, get grand totals to show not just the sum but also give the ability to count, average...etc
John Matta
shared this idea
Hi John,
Kenneth beat me to it, but this is already possible today with Excel – the Grand Total will show whatever aggregation you’re using for the column. To change that,
1. In the PivotTable Fields pane, click on one of your fields in the Values section.
2. Choose Value Field Settings.
3. In the scrollable list that appears, choose a calculation type other than Sum.
Hope that helps,
Dan [MS]
3 comments
Comments are closed-
Feargal Hogan
commented
Yes, so much this. i want to use count(<field>) in the crosstab and average(vcount(<field>)) in the total columns and rows
-
John Matta
commented
Hi Dan,
Yes, I'm well aware of that. But my suggestion is actually to give the grand total column the ability to show different calculation from the aggregation of the pivot table columns. For instance, if I have a product price from different suppliers, I'd need to see the actual price for each supplier in the colums and to see how many suppliers submitted a price for that product..or even take it one step further and show the distinect count to show how many different prices I have for each product.
I hope I was able to articulate my point.Thanks
-
Kenneth Barber commented
It seems like you can already do this. In the PivotTable Fields pane, click on one of your fields in the Values section. Choose Value Field Settings. In the scrollable list that appears, choose a calculation type other than Sum.
With that said, it would be nice if the Grand Total would change terminology to Grand Average, etc.