Forum Discussion

ironryan77's avatar
ironryan77
Icon for Kudo Commander rankKudo Commander
9 years ago

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_...
Need Help
ironryan77's avatar
ironryan77
Icon for Kudo Commander rankKudo Commander
9 years ago

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:

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

ironryan77

 

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,