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.
 

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

Sorting pivot table by specific field (column) 1
Pivot table 1
Pivot table calculated field Count(field) / sum(field) 0
Advanced Pivot Table 1
Pivot table from CSV data, problem getting a percentage from the total 2
Pivot Table Help! 1
Re: Differences instead of sums in pivot table 2
Pivot Table Not Behaving as Expected 1

Back
Top