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
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

ironryan77

 

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,

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,