how do I get more than one sub-total in pivot tables?

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

Guest

I am using pivot tables to show summary HR recruiting data. The data columns
are nested at three levels - priority(a, b or c), type(add/replace), number
of reqs and number of positions. The pivot table automatically gives me
sub-totals within the priority so I get number of reqs that are adds of
priority A for example. I also automatically get a total of number of reqs
and total of number of positions. What I'm trying to get is the sub-total
of number of reqs that are adds regardless of priority.
 
Move Type to the column area, and you'll get columns with totals for Add
and Replace.
 
Back
Top