Pivot Table Grand Total Placement

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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
Average of Subtotals in Pivot Table 0
Grand Substraction instead of Grand Total in pivot table 3
Totals from Pivot tables 1
Pivot Table 1
pivot table grand totals not showing for all columns... 1
Pivot table 1
Pivot Table Totals When Using Pages 1

Back
Top