Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create a matrix with only a specific total

Hi,


Is it possible to create a "matrix" that only shows the EBIT total? Instead of the total of all lines? 

 

Like this:

 

Best regards. 

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous,

     

    Is it your requirement? 

    I am also attaching PBIX file.

     

    Regards,

    Ravi

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Anonymous, 

      That's what I want, how do I do it?

       

      Thanks for your attention, 

       

      Best regards. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Anonymous,

         

        Please follow my pbix file.  I had shared in my last message.

        In that pbix first we are filtering total EBIT from your main dataset then created a new table with union of filtered EBIT total and your main dataset.

         

        Best Regards,

        Ravi