Pivot Table

[Naz]

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?

 

[Debra Dalgleish]

You could add another copy of the April field to the Row area.
There, click the dropdown arrow for April, and remove the check marks
from every item except 1.

 

[Naz]

Thanks.
Unfortunately it still doesn't work. The table still gives the right number
but the drill down still shows all the cases.

 

[Debra Dalgleish]

I used your sample data, and it worked. Do you have other fields in the
pivot table? What fields are in the row, column, and data areas?