Totals For An Inside Row Field In a Pivot Table

[jbesr1230@hotmail.com]

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.

jbesr1230@hotmail.com wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html