I have a Multi value parameter and I have set some specific values to that parameter, eg: Maths, Chemistry, Physics, Biology
Also I have separate columns for each of these scores. Ie, Maths Score,Chem Score,Phy Score,Bio Score. I need to display this columns only if the user selects that values in control. Ie, If user selects maths ,Chemistry I need to display Maths Score, Chemistry score columns and remaining columns shouldnt be there.
So basically, the columns in pivot table need to appear and disappear based on filter selection. How can we do that. Note : Parameter should be Multi valued.
Hello @Ganga
In QuickSight, there is currently no functionality to dynamically update what fields are in the field wells of visuals. You can make calculated fields to change the values in the field but not remove and add the fields entirely.
This wouldn’t look as good, but you could use conditional rules on a text box so that when your multi-value parameter doesn’t include a subject, it layers over that subject score column.
I can mark this as a feature request.