Totals For An Inside Row Field In a Pivot Table

[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.

 

[Debra Dalgleish]

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.