Dynamic Column Select

[marcos_osorio]

Hi, I'm having this problem:

I have a Matrix like this:

                                    UNITS         AMOUNT       MARGIN

Country A

      Customer A

      Customer B

Country B

      Customer C

My boss wants the possiblity of selecting the columns.

for ex. If he selects Unit, the matrix must show only the Units Column, if he selects Units+Amount the matrix should show the selected ones.

Is there a way to do this?

Thank you very much.

[parry2k · Accepted solution]

@marcos_osorio you cannot hide the columns based on selection but in your calculated measure you can check the selection and if selection condition is not met then return blank() in the measure. This way it will not show the value of the columns that are not selected. Hope it helps.

[marcos_osorio]

Thank you very much.

Regards,