Forum Discussion
Changing axis in matrix
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,
Thank you, but when I tried putting my values in Rows, it no longer summed them. Now it just has a list of all Total Volume and TTM Volume values as below:
In matrix, we should put dimension field in rows and columns which are used to slice fact data. You can't put the fact data field into Rows. It will return nothing but a grand total.
Regards,