Forum Discussion
Matrix Visualization Multiple Columns & Rows of Data
I am using the Matrix visualization to present Revenue, COGS, Processing Cost, Gross Profit Margin Data. I've changed the Matrix values to "Show on Rows" so that the headers are in the first col...
Thanks for the feedback; I've added additional images of my data.
Hi jaybi11 ,
It seems that you want to show result in Matrix, right? I think you could try to transform the data structure by choosing "product cost", "Revenue" and "amount" columns and click unpivot it. Then you could create measure and use this in Matrix.
If possible, could you please inform me more detailed information (your sample data and expected output, I didn't find "_amt" in your sample in image)?
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.