Forum Discussion
Changing axis in matrix
Thank you Victor. I actually have more than one Attribute column; will Pivot Column still work in this case? Or do I need to string all of my Attribute Columns together into one column to use as the Pivot?
Also, I couldn't figure out which Value to Pivot on. (I have more than one Value column too). When I tried Pivoting on just one Value column, I got this error below (Transport Month was my date_str column):
This was the error details:
Error Message: Something's wrong with one or more fields: (Payor_Scorecard_All_Payors_Final_PROD) Transport Month Stack Trace: Invocation Stack Trace: Activity ID 20eaf971-21ad-d55b-4801-d5fbcea2fc5a Time Wed Oct 05 2016 13:58:38 GMT-0500 (Central Daylight Time) Version 2.38.4491.282 (PBIDesktop) Client Error Code Missing_References
Can you put some sample table and the result that you expected?
With this input i'll try to think a solution.
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:
