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_...
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,