Hello,

I have a problem with a pivot table that i have. Its is a sum of how many
cases of Type1, Type2, Type3 are open each month. The numbers that the table
gives is correct. But when I drill into the number the data it gives is not
exactly what i want.
Let me illustrae, the cases below are Type1, a 1 indicates the cases is open
in that month, anything else indicates that is is closed

Source Data

April May June July Aug Sept
Type1 1 1 1 1 1 1
Type1
Type1 0 0 0 0 0 0
Type1 1 1 1 0 0 0

Pivot Table

Type1 2 2 2 1 1 1


The table is a summary of this info. So for April the table gives 2 which is
correct. But if i drill into the table it returns all 4 cases, when really i
only want to see the 2 open cases. I then have to apply a filter, which is
not ideal.
Is there a way around this?

--

_______________________
Naz,
London