Excluding the one of the Regions

[Anonymous]

Hi,

I have the chart with Region and sales values, now in the chart I need to exclude one of the values

and it should be done on the UI side only not onto the scripting end

may be set analaysis would do. Some one suggest me

[alexandros17]

In your table go to the dimension and write in it (Calculated...)

If(Region='UK', Null(), Region)

Now check the Suppress null values box and ...

Let me know

[ashfaq_haseeb]

Hi use this as expression.

=Sum({<Region-={'UK'}>}Sales)

have a look at attached application.

Regards

ASHFAQ

[PrashantSangle · Accepted solution]

Hi,

Use calculated Dimension as

if(not WildMatch(Region,'uk'),Region)

Regards

[ashfaq_haseeb]

Hi,

Is something wrong with my answer?

Regards

ASHFAQ

[Anonymous]

Hi,

I want the condition to be set in calculated dimension as per my requirement, I cant filter out this in expression