how to ignore one value in straight table?

[Akina0929]

Hi ,

I have straight table that consist country as dimension, in that i don't want to show one country how can we do please help me .

Thanking you

[tamilarasu]

Hello,

Goto Dimesnion Tab and type the below in Calculated dimesion:

If(Country<>'CountryName', Country)

Enable "Suppress When Value is Null" Option

[Akina0929]

thank you Nagaraju

[stabben23 · Accepted solution]

Use set analysis in Your Expression(s) is another option

sum({<Country -={'YourCountry'}>}Value)