Can we pivot data in QuickSight?

No not today, however with AWS Glue DataBrew you can Pivot and Unpivot data (technically your example is an UNPIVOT).

If you wanted to do it in QuickSight it would require Custom SQL where you select all the dimension columns and one of the measure and then UNION ALL with another select with all the dimensions and the second measure, etc.

1 Like