Allow for dynamic Selection of Columns in a pivot table based on user selection

Question & Answer
,
1

Would dynamic selection of columns be possible for a date field.

Lets say initially a pivot table is in the format below with months in the columns.

Month 1 Month 2 Month 3 Month 4

Instead of creating a new pivot table I would like the user to be able select to have the Week replace month in the columns recreating the same pivot table as:

Week 1 Week 2 Week 3 Week 4

I have tried: https://democentral.learnquicksight.online/#Analysis-TipsAndTricks-Interactivity-Dynamic-Dimensions-and-Measures but I can’t seem to make this work for date fields?

2

Hi @iamsam
you could use the drill up and down function within the pivot table.
Otherwise I would use two different tables and switch by a control.
BR

3

Hi @iamsam
any update on you side?
BR

4

I dont think drill downs are supported for pivot tables:

I can add multiple tables, but my goal was to reduce the amount of real estate all the views take up in the overall dashboard. If I have three pivot tables one for weekly another for monthly and a third quarterly this requires someone to navigate to the correct table and possibly have to scroll.

I just think it would be a match nicer experience to toggle a filter and the correct granularity is shown.

5

Did you test it? Because I tried it and work fine.

IMG_20240111_175627
IMG_20240111_1756271080×386 68 KB

6

Hi @iamsam
could you solve your issue?
BR