How to exclude 2 dimensions and its corresponding measure

[BijoyTV]

Hi Team,

I need to exclude two dimensions and its corresponding measure.

For eg.

Dimension - Germany , India, UK, US and Japan

Measures - 100, 200, 300, 400, and 500

I want to remove Germany and India so that my new display will be without Germany and India & also without its corresponding measures 100 and 200.

Thanks

[AshutoshBhumkar]

Hi,

You can exclude those values in set analysis.

Like, Sum({<Dimension -={'Germany','India'}>}Sales)

Thanks,

Ashutosh

[BijoyTV]

Hi Ashutosh,

Thanks for your reply. Our system is connected to a treasury system so all the dimensions and measures are defined at the treasury system.

I'll share a screenshot for your reference.

I need to remove two countries and its corresponding values too.

Thanks

Bijoy

[AshutoshBhumkar]

When you create a table and add Dimensions and Measures. You need to put the same set into "Cash Balances" measure.

That will exclude 2 countries from your table.