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_string value as a Column instead, it groups all of my aggregate measures under each date_string value. I want my measure values to display from top down, not left to right. How do I do this?
I have something like this:
date_str A B C 201601 A1 B1 C1 201602 A2 B2 C2 201603 A3 B3 C3
But I want it to look like this:
201601 201602 201603 A A1 A2 A3 B B1 B2 B3
9 Replies
Thanks, Ravi. does Pivot Column only work one column at a time? I tried using this function, but I couldn't figure out how to aggregate the data. After doing Pivot Column and choosing one of the metrics to pivot on, it still listed all of my metrics in the header row instead of column row. "Transport Month" is the name of my date_str column that I want to pivot, and Total_Volume is the name of one of my metrics that I want listed in one row instead of one column.
hi ironryan77
Follow this steps:
1.Your original table
2.Select A,B,C and click to Unpivot Columns
the results is:
2.Select Date_Str and click to Pivot Column
And the results is:
