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

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

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

_______________________
Naz,
London


"Debra Dalgleish" wrote:

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

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?

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