Dynamic Pivot Columns per Dimension

[ajque]

Hello All!
Anyone here that can share  a way to apply  switchable column values in a pivot table using either dropdown/button feature of blox?

The idea is if I choose Dimension 1 (Channel), the columns will change to all values for Channel (e.g. Chat, Phone, Email), then if user chooses Product Type (e.g. Home, Renter, Motor), then columns will switch to values under Product Type. 

Below is a sample of how it can look:

Would appreciate any tips you may share, have a great day!

[HamzaJ]

Hey @ajque 

I never tried something like this. However I think you can combine the Blox-templates referenced here (https://community.sisense.com/t5/knowledge/blox-metadata-changer-list/ta-p/8920) and make something like this possible. 

You could also take a look at the Expandable Pivot-plugin (https://www.sisense.com/marketplace/premium-expandable-pivot-table) from @Ravid_PaldiTeam  .  It offers the feature to set presets on the table. 

Hamza

[ajque]

Thanks for the immediate response! for some reason though the links listed in the first reference you gave me are all giving me error 404 (page cannot be found). Would you know if there's a another link I can check?

[HamzaJ · Accepted solution]

These links should work:

https://community.sisense.com/t5/knowledge/changing-measures-in-the-entire-dashboard-using-blox-user...

https://community-old.sisense.com/hc/en-us/community/posts/360047413173-Using-BloX-To-Dynamically-Ch...