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 wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html