Pivot table with 3 value series Double-click summary

[andydtaylor]

Hi,

I just got caught out on something I haven't encountered before and I'd like to know if there is a proper solution or just the workaround I can think of. FYI I am joyously working on Excel 2010.

I have a pivot with 3 series of values. However when I double click on any one of the totals it gives me all of the rows for all of the 3 data series. This strikes me as strange. I've tried adding subtotals for various things I am filtering on but to no effect.

Is this "by design" behavour?

The obvious workaround is to make 3x pivot tables but is there an alternative?

Regards,

Andrew

 

[andydtaylor]

I am deeply puzzled... This was my 1st Pivot:

Sum of Dual_OB_Incr 502
Sum of DAC_FI_Incr 30
Sum of DAC_EQ_Incr 121


So I made 3 separate pivots, one for each data series.

For example with this pivot:

Sum of Dual_OB_Incr 502

I double click on 502 and it gives me 653 rows.

I know I'm using software a decade old, but this can't be right, can it?

 

[andydtaylor]

I'm a massive idiot. My issue was that my totals were sums of 0/1 flags and not item counts. So brought each 0/1 flag into the filter, with filter set to 1