Forum Discussion
pivot data
In the query editor, select your Period column and hit Unpivot Other Columns. Then select Period again and hit Pivot Column. Value should be the Values column, then open the advanced options and change it to Don't Aggregate.
I would only select Period and Upivot Other Columns
Then create a Matrix place Period in Columns, Category (Attribute) in Rows and Value in Values
The data will remain in better shape for analysis than your final desired output but you'll still be able to achieve it :smileyhappy:
I would only select Period and Upivot Other Columns
Then create a Matrix place Period in Columns, Category (Attribute) in Rows and Value in Values
The data will remain in better shape for analysis than your final desired output but you'll still be able to achieve it :smileyhappy:
how do i change the order of the rows under attribute?