Matrix percentage Options

[Guyakobov]

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

[v-piga-msft]

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]

HI, 

Thank you, how this measure will go?

Regards 

[v-piga-msft]

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