Forum Discussion

jaybi11's avatar
jaybi11
Frequent Visitor
6 years ago

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...
Need Help
  • jaybi11's avatar
    jaybi11
    Frequent Visitor
    6 years ago

    Thanks for the feedback; I've added additional images of my data. 

    • dax's avatar
      dax
      Community Support
      6 years ago

      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.