Pivot Table Grand Total Placement

G

Guest

Does anybody know if it is possible to get Grand Totals on a pivot table to
appear at the top of the pivot tables columns rather than the bottom (not
subtotals, I know you can do that)? I can't find anything that says it is
possible with Grand Totals so I figure I would ask the forum.

Thanks,
Bill Horton
 
D

Debra Dalgleish

No, the column grand totals can't be moved from the bottom of the pivot
table, and row grand totals can't be moved from the right.
 
C

comish4lif

Although ti would not technically be part of the pivot table, you could
do this:

- Complete your pivot table (PT).
- Click on row 1, and insert a new row (or 2) to slide the PT down.
- Now, in row 1, use a vlookup formula to display the "Grand Total" at
the top of the sheet. e.g. =VLOOKUP("Grand Total",$A$6:$K$79,3,FALSE)
where a6:k79 in the range containing the PT, and 3 is the row of the
Grand Total I wish to display.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Grand Total Issue 3
pivot table grand totals not showing for all columns... 1
Grand Substraction instead of Grand Total in pivot table 3
Pivot grand total 1
Totals from Pivot tables 1
Pivot Table 1
Pivot Table Totals When Using Pages 1
Grand Total for Rows not Working in a Pivot Table 1

Top