Pivot Table Row Total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Excel 2000, am I able to show the row total in a pivot table at the
beginning of the row i.e. to the left of the data area, rather than at the
end, or right side?
 
Hi

No, the position is fixed at the Right for Row totals and at the bottom for
column Totals.
If it is because you have a very wing or very long PT, and would like the
see the totals on screen, you could Insert a Row above your PT or a Column
to the left of the PT.

In the appropriate cells type = and point to the relevant totals and it will
generate the correct GetPivotData formula for you, to repeat the values form
the Grand Totals.
 
Thanks Roger, I can work around that.
--
Robo


Roger Govier said:
Hi

No, the position is fixed at the Right for Row totals and at the bottom for
column Totals.
If it is because you have a very wing or very long PT, and would like the
see the totals on screen, you could Insert a Row above your PT or a Column
to the left of the PT.

In the appropriate cells type = and point to the relevant totals and it will
generate the correct GetPivotData formula for you, to repeat the values form
the Grand Totals.
Click to expand...
 

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

Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table Column Totals - XL2003 5
Pivot Table - show all row fields 1
Pivot Table - 3
XL2007 - Pivot Table Limitations 2
Grand Total for Rows not Working in a Pivot Table 1
Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table - move Totals column 1

Back
Top