How to hide a column/row by clicking a checkbox?

[charlyh]

Hello everyone,

I have this active report in which I created a custom table inside a data deck (the custom table includes: measures, tuples, and data items which are calculations between measures).

(more explanation on the data deck in case you didn't understand me before: so the table inside the data deck contains different business units and their results, so it contains revenue, cost, gross profit, forecast, etc...)

There are also 2 drop down lists which are connected to this data deck that changes them according to what you need (I use it to show the data according to the countries I need or years needed)

-My question is: is there a way that I could add checkboxes or something with my current setup and when they are clicked, a column or a row is added? For example if I wanted to click on the checkbox so that a new column is added in which it shows me the budget or the comparison of our costs against budget etc?

Thank you for your help! :)

[MFGF]

Hello everyone,

I have this active report in which I created a custom table inside a data deck (the custom table includes: measures, tuples, and data items which are calculations between measures).

(more explanation on the data deck in case you didn't understand me before: so the table inside the data deck contains different business units and their results, so it contains revenue, cost, gross profit, forecast, etc...)

There are also 2 drop down lists which are connected to this data deck that changes them according to what you need (I use it to show the data according to the countries I need or years needed)

-My question is: is there a way that I could add checkboxes or something with my current setup and when they are clicked, a column or a row is added? For example if I wanted to click on the checkbox so that a new column is added in which it shows me the budget or the comparison of our costs against budget etc?

Thank you for your help! :)

Hi,

If you use a List object, you can add the relevant items to your list as columns, and for each column you can use the Column Visibility property to hide or show that column based on your active report variable. Is this a solution you can use?

Cheers!

MF.