Dashboards & Visualizations

Added and removing columns based on dropdown fields

Path Finder

Hi All,

Currently I have a pivot table within a dashboard. I've added a dropdown that filters the pivot table based on the selected dropdown item. I was wondering is there a way where I can add a column to the pivot table if a particular dropdown value is selected. 

E.g. Something along the lines of the following logic: if($dropdownfield$=="cartridge") add column "Catridge" remove column "Artefact"

Feel free to ask for further clarification if the question doesn't make sense.

Any help would be highly appreciated. 

Labels (2)
0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.