Totals For An Inside Row Field In a Pivot Table

  • Thread starter Thread starter jbesr1230
  • Start date Start date
J

jbesr1230

Hello,

Is it possible to get totals for an inside row field in a pivot table?
I have a table in layout as follows:

Row Fields - Section, Year
Column Fields - Rev, Exp, FTE
OR:


...........................................Rev...........Exp.............FTE
Sect............Year
3425...
.....................2000................$$$.........$$$.........##
.......................2001.................$$$.........$$$.........##
........................2002................$$$.........$$$.........##
3428...
.....................2000................$$$.........$$$.........##
.......................2001.................$$$.........$$$.........##
........................2002................$$$.........$$$.........##
.....ETC.

What I would like is to a Total by Year for all sections.

Thanks.
 
You could move the Year field to the column area, then the column totals
would be per Year, and the row totals would be per Section.
 
Back
Top