topic Re: Hide a column from table in App Development

Hide a column from table

CHAY-92 — Mon, 21 Aug 2023 10:45:36 GMT

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 — Mon, 21 Aug 2023 11:19:31 GMT

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 — Mon, 21 Aug 2023 12:56:21 GMT

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 — Mon, 21 Aug 2023 12:58:16 GMT

so uncheck show zero values under add ons

CHAY-92 — Mon, 21 Aug 2023 18:14:22 GMT

Hi martinpohl

Tried to hide the dimension with the below condition

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

Got the result now 😀

Thanks for your support