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.

Bob wrote:
> 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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html