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.