Show/Hide columns in table based on filter pane selection

[havha]

I searched the forum but couldn't exactly find what i'm looking for.

I've a dashboard with lots of KPI's and filter on each KPI (filled/Not Filled)

Beneath a table. I now want to show:

• Some standard fields such as ID and Name
• Only the column when in the filter (connected to the KPI) "Not Filled" is selected.

So for instance when the filter next to "Date of Creation" is set to "Not Filled" i want to appear the column "Date of Creation" in the table below. When nothing is selected or "Filled" is selected i don't want the column "Date of Creation" to be shown.

See attached screenprint

[Gabriel]

Hi

But you're showing it as field in the screenshot. So what's the fieldname to select from? And is this data island? Please tell us more about this field with values of Filled and Not Filled

[havha]

=aggr(IF([Date of Creation] ='', 'Not Filled', 'Filled'),[Date of Creation])

Then, in the column condition in your table, write the formula I gave you before:

=if(GetFieldSelections([Date of Creation]) = '',1,0)

This did the trick!

Many thanks.

Hans

[lorenzoconforti]

Glad it helped. Please close the thread as solved