Hi guys,
I noticed a problem when I am dragging a specific field in the crosstab, the measure is not updating and remains aggregated when I removed that specific field.
To make it more understandable (Hopefully) Here is an example:
A measure "No. of Students"
An attribute "Birth Year"
An attribute "Gender" (Male/Female)
An Attribute "Team" (Alpha/Beta)
Lets say this is the crosstab in powerplay and I dragged these fields:
No. of Students 2000 2001 2002 BirthYear
Alpha Male 15 10 12 37
Alpha Female 12 12 11 35
Gender 27 22 23 72
Beta Male 5 10 15 30
Beta Female 4 8 12 24
Gender 9 18 17 54
Team 36 26 29 78
Then I removed the Gender Field, and change it to a specific gender(Female):
No. of Students 2000 2001 2002 BirthYear
Alpha Female 12 12 11 35
Beta Female 4 8 12 24
Team 16 20 23 59
Then finally I removed the "Female" Field:
No. of Students 2000 2001 2002 BirthYear
Alpha 12 12 11 35
Beta 4 8 12 24
Team 16 20 23 59
The values remains the same as if it is still filtered by Female Gender.
I am expecting to have this kind of result:
No. of Students 2000 2001 2002 BirthYear
Alpha 27 22 23 72
Beta 9 18 17 54
Team 36 26 29 78
Any idea on this? I'm a newbie in cognos. Thank you in advance!
Regards,
Gerard