how to create a collapsable column

[#1]

hi,

i would like to make one of the dimension columns in the table collapsable, so if in the sales table i have a country column and a client column, i want the client column to be collapsable so the user is able to see total sales per country if they wanted to, without the sales splitting into the different clients in each country.

[alexandros17 · Accepted solution]

You can use a Pivot table or you can declare a variable and use it (Setting the variable with a button) in the conditional visualization of the column

Let me know

[#3]

Hi,

Create a pivot table with country and client as dimension and sum of sales as expression.

Warm Regards,

Joshmi