Forum Discussion

Guyakobov's avatar
Guyakobov
Helper II
7 years ago

Matrix percentage Options

HI,

 

In the matrix visual there are 2 percentage options - Percent of grand/column total.

I have 2 rows fields and 2 value fields ( one with grand total and the other of column total that is based on the same 'Accounts' field from the table).

i wish that the grand total will calculate the percentage from the grand total that is 7000 accounts and the column total will calculate the percentage from each subtotal but it gives the same result. 

http://prntscr.com/ni8264

 

Thanks

 

 

   

Need Help

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Guyakobov ,

    I'm afraid that we cannot change the subtoal in matrix, it is calculated automatically based on your value in matrix.

    You may could create other measure to achieve your desired output as a workaround.

    Best Regards,

    Cherry

     

    • Guyakobov's avatar
      Guyakobov
      Helper II
      7 years ago

      HI, 

       

      Thank you, how this measure will go?

       

      Regards 

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        Hi Guyakobov ,

        Please share the sample data which could reproduce your scenario and your desired output so that I could copy and paste to have a test on your data.

        Best Regards,

        Cherry