Can I hide expression only for some specific dimension value?

[uacg0009]

Hi Guys,

I just want to know can I hide expreesion only for some specific dimensnion value?

Now I have example data :

What I create is :

But what I want is that I don't want to see the sum(PEOPLE) for VEN='AAA'

it should be like :

VEN	AAA	BBB	BBB	CCC	CCC
BOSS	SALES	SALES	PEOPLE	SALES	PEOPLE
HAHA	100	200	4	-	-
LOL	300	400	6	500	7

I try to use condition to limit this, but it didn't work, and I think maybe macro can do this, but it's hard for me, 'cause I don't know how to use VB.

So do you know how to solve that? or any other way to do that?

Thanks.

Aiolos Zhao

[swuehl]

I believe you can't remove or hide an expression column only for specific dimension values.

You could maybe change the text color.

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[vikasmahajan]

PFA

Vikas

[uacg0009]

Thanks for reply, and I just want to do a brainstroming, so maybe we can find another way to solve this.

Thanks.

Aiolos Zhao

[uacg0009]

Thanks for reply, but I can't see the VEN='AAA' in your qvw, actually I need to see AAA in table.

Thanks.

Aiolos Zhao

[uacg0009]

Hi Gysbert,

Well, you are my idol, always, that's so cool! And thank you so much.

But the real data is a little complex, so I need to try to make a large table to stroe these expression names.

Thanks again!

Aiolos Zhao