Forum Discussion
Solved
Vertical sub column layout in Matrix
Hi All, I am trying to apply a greater control over the appearence of data returned in a Matrix from an SQL View. Currently I am returning the results as 3 seperate values (summed) for each c...
Hi RandomBI,
To what I can see I believe you didn't follow the steps I identified see below a small guide and see if this is the result you want:
- Unpivot the columns - Qty Sold, Unit Price and Weight
- You need to choose all three columns and then unpivot
- This will give you one column with attribute and another with values
- Use the Attribut for your rows and the values for your values in the table view
Think this is what you need.
Regards,
Mfelix
- Unpivot the columns - Qty Sold, Unit Price and Weight
Hi RandomBI,
To what I can see I believe you didn't follow the steps I identified see below a small guide and see if this is the result you want:
- Unpivot the columns - Qty Sold, Unit Price and Weight
- You need to choose all three columns and then unpivot
- This will give you one column with attribute and another with values
- Use the Attribut for your rows and the values for your values in the table view
Think this is what you need.
Regards,
Mfelix
