Hide a column from table

[CHAY-92]

Hello all

Need urgent help

I have table with 2 rows ,one dimension is country  and measure is sales

Under country dimension I have 8 countries 

Out of 8 I need to hide 1 country .

Is there any way to solve this problem.

Thanks 🙏

[martinpohl]

Hi,

when your measure is

sum(sales)

and the country you want to hide is Argentina, change your measure to

sum({<country-={'Argentina'}>} sales)

Regards

[CHAY-92]

Hi martinpohl,

Thanks for your reply, I tried your solution but my country name is not hiding,just it shows sum(sales) is zero.any leads .

[martinpohl]

so uncheck show zero values under add ons

[CHAY-92]

Hi martinpohl

Tried to hide the dimension with the below condition

(If ( company<>'Argentina', company)) 

Got the result now 😀

Thanks for your support