Controlling Pivot Tables Fields on Dashboard

Question & Answer
1

Hi there,

I’m looking for a way to control which data field is shown in the rows of my pivot table.

Ideally there would be a dropdown list that would contain the fields I would like the user to be able to view, and when one is selected the pivot table shows my data sliced that way.

I haven’t been able to find this feature if it exists. Does anyone have any advice?

Thanks!

2

You can see how it’s done in this demo. The demo uses a bar chart but you can do the same in any type of visual.

https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Interactivity-Dynamic-Dimensions-and-Measures

1 Like