ajque
08-22-2023Cloud Apps
Dynamic Pivot Columns per Dimension
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!