Forum Discussion
Changing axis in matrix
How do I change axes in a matrix so that my rows become columns and vice versa? Currently I have a date_string value as my Rows, and the other aggregates as Values. But when I try adding this date_...
OK existing sample data:
date_str Attribute1 Attribute2 Value1 Value2 Value3 201601 A1 B1 C1 D1 E1 201602 A2 B2 C2 D2 E2 201603 A3 B3 C3 D3 E3
Here is how I want this to look:
201601 201602 201603 Value1 C1 D1 E1 Value2 C2 D2 E2 Value3 C3 D3 E3
The attributes are not relevant to the final output because the attributes are all slicer selections. Which attributes appear depend on their selection. Make sense?
I assume you have a table like below:
However, you should have Value category column and date_string column in your source table, your raw data should be like:
So for your requirement, you just need to put the Value type into row group and date_str into column group.
Regards,