COGNOiSe.com - The IBM Cognos Community

Hello all,

I have one dimension with 2 levels and for example my data is:

DIMENSION	MEASURE
01 - CHANNEL	10
*01 - TELEPHONE	4
*02 - INTERNET	6

Level 1: 01- CHANNEL, Level 2: 01 - TELEPHONE, 02 - INTERNET

I would like to filter my crosstab for example by 01 - TELEPHONE and show only parent level, something like:

DIMENSION	MEASURE
01 - CHANNEL	4

But my result is always:

DIMENSION	MEASURE
01 - CHANNEL	10

How I could filter some members for the dimension and show the value filtered in the parent level or rootmember?


Thanks