Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙏
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
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 .
so uncheck show zero values under add ons
Hi martinpohl
Tried to hide the dimension with the below condition
(If ( company<>'Argentina', company))
Got the result now 😀
Thanks for your support