Forum Discussion

pyramid1's avatar
pyramid1
Frequent Visitor
3 years ago
Solved

Matrix - Total between two columns with two row header.

Hello expert, I need some help with Matrix.   Here is my sample data: I am expecting below output: While playing with matrix , I couldn't get to expected output. So anyhelp would be a...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

     

pyramid1's avatar
pyramid1
Frequent Visitor
3 years ago

Thanks Kim. I was able to use pbix that you attached. Is there a way to color whole salary section and underneath columns to be in one color and whole Tax section in another color?

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

 

 

  • pyramid1's avatar
    pyramid1
    Frequent Visitor
    3 years ago

    Yep that makes sense. I am doing more formatting on "Diff" column. So if value Diff-Measure (under Salary) is postive then make it green. If value Diff-Measure (under Salary) is negative then make it Red. Is this kind of coloring possible.

     

     

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      3 years ago

      Hi,

      Please check the below picture and the attached pbix file.

       

       

       

       

      • pyramid1's avatar
        pyramid1
        Frequent Visitor
        2 years ago

        Hi Kim,

        This is old thread but wondering if it is possible to add additional column at the end to write down some comment/description (like last two columns )?