how to ignore one country sale 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

[marcus_sommer]

You could exclude this country within the dimension per: if(Country = 'x', null(), Country) and hiding NULL's within the dimension or also with a set analysis condition within the expression like: sum({< Country -= {'x'}>} Value).

- Marcus

[MK_QSL · Accepted solution]

SUM({<Country -= {'CountryName'}>}Sales)

[Akina0929]

thank you Marcus Sommer it's working

[Akina0929]

thank you

[Anonymous]

Hi,

Try below.

In the straight table go to Properties  -> Dimensions --> 'Add Calculated Dimension' --> add the expression

If(Not Match(country,'Canada'),Country) --  It will show all the countries except Canada. Also check 'Suppress when value is null'.

Look at the screenshot below.