Hello,
I wonder if it is possible to have a pivot table with a grand average instead of a summed total?
I can set the field value to average but that averages everthing rather than just the total.
Many thanks
Hello,
I wonder if it is possible to have a pivot table with a grand average instead of a summed total?
I can set the field value to average but that averages everthing rather than just the total.
Many thanks
Hi LB79,
when you set the aggregation as average, it averages all the subtotals as well... If you need sum, you can have another column on side of pivot.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks