Pivot table with "If" statement in Expressions

[#1]

Hello Experts,

I am trying to use a pivot table which has "if" statement in Expressions.

What I want to see is to view all data which are not selected in list boxes.

For example, If I select a value of the Region dimension , the pivot table only displays values ​​for the selected dimension.

But If I change  an expression which does not use the "if" statement, it work fine.

Unfortunately I can not change the expressions , because there are no ways to think. 

So if you have any idea, please help me.

Thanks,

WanKi,

[Gysbert_Wassenaar]

See attached qvw.

[#3]

Gysbert ,

Thank you so much !

It is almost same.

I tested the qvw you sent .

But if I click the value 'AAA' in Region dimension, the Pivot table displays data except the 'AAA'.

Please confirm your file. ^^

Thank you,

WanKi,

[Gysbert_Wassenaar · Accepted solution]

What I want to see is to view all data which are not selected in list boxes

That's what the example I posted shows. Only the data from the regions and countries not selected are shown.

If all you want is to ignore the selections and show data from all regions and countries then use {1} or {<Region,Country>} as set modifier.

[#5]

Gysbert ,

I am very sorry about my post.

It was my mistake.

What I want to see is to see all data regardless of the selected values.

And then I will click the data on the pivot table.

It was that I try.

Thank you,

WanKi,

[#6]

Gysbert ,

Finally I got it .

I did as you said.

Thank you very mych ~~

WanKi,