Multiple Grand Totals in the same Pivot Table

FunkiDooks

New Member
Joined
Dec 14, 2005
Messages
1
Is it possible to have 2 Grand Total Columns in the same pivot table, one reflecting the sum and the other reflecting the average. This also needs to be done without using a caluclated item as the underlying data will change periodically. Any ideas???
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Watch MrExcel Video

Forum statistics

Threads
1,118,536
Messages
5,572,767
Members
412,482
Latest member
arooshrana2
Top