Pivot Table Subtotals
 

Hello all

Is there a way of making pivot tables only subtotal if there is more than 1
item in the second row field? That probably doesn't sound very clear - so
I've created an example pivot table below to explain what I mean:

Month
Builder Builder Town Jan-08
Builder 1 Town A 8,890
Town B 2,982
Town C 82
Town D 2,042
Builder 1 Total 13,996
Builder 2 Town E 6,282
Builder 2 Total 6,282
Builder 3 Town F 3,805
Builder 3 Total 3,805
Builder 4 Town G 7,570
Town H 3,577
Builder 4 Total 11,147
Builder 5 Town I 1,846
Builder 5 Total 1,846
etc...

So would there be a way of displaying the subtotal for Builders 1 & 4 as
they have more than 1 town but not having the subtotal for the other builders
as they only have one builder so the subtotal is totalling one line. If I
collapse the field on these then it only shows the subtotal but not the town,
so that's not an option.

I ask this because I use some large pivot tables at work and usually most of
the subtotals are for one thing each time so are unnecessary and it then
takes a while to format this as I copy and paste the table as values and
delete all the subtotals that aren't needed. So if there is a way to do this
on the pivot table it will save me so much time!

Thanks very much for any help that is given

Pivot Table Subtotals
 

Subtotals will be added to each grouping regardless of the number of data
items in the group. There is no way around that.
--
HTH...

Jim Thomlinson


"Charlotte" wrote:

Hello all

Is there a way of making pivot tables only subtotal if there is more than 1
item in the second row field? That probably doesn't sound very clear - so
I've created an example pivot table below to explain what I mean:

Month
Builder Builder Town Jan-08
Builder 1 Town A 8,890
Town B 2,982
Town C 82
Town D 2,042
Builder 1 Total 13,996
Builder 2 Town E 6,282
Builder 2 Total 6,282
Builder 3 Town F 3,805
Builder 3 Total 3,805
Builder 4 Town G 7,570
Town H 3,577
Builder 4 Total 11,147
Builder 5 Town I 1,846
Builder 5 Total 1,846
etc...

So would there be a way of displaying the subtotal for Builders 1 & 4 as
they have more than 1 town but not having the subtotal for the other builders
as they only have one builder so the subtotal is totalling one line. If I
collapse the field on these then it only shows the subtotal but not the town,
so that's not an option.

I ask this because I use some large pivot tables at work and usually most of
the subtotals are for one thing each time so are unnecessary and it then
takes a while to format this as I copy and paste the table as values and
delete all the subtotals that aren't needed. So if there is a way to do this
on the pivot table it will save me so much time!

Thanks very much for any help that is given