Subtracting two columns that are % of grand total

[dethompson97]

I would like to calculate the difference between these two columns that are each shown as a % of grand total.

Hi All,

I have two columns in my matrix report that I am showing as % of grand total.  I would like to subtract these two.  

So if the column value A was shown as 20.48% and column value B was shown as 18.75% I would like to create a third column in the report that would show 1.73%.   I can show each column A and B as % of grand total but how do I create another column in the table that shows the difference between the two.

Thanks!

Dawn

[v-yulgu-msft · Accepted solution]

Hi @dethompson97,

Please have a look at below threads:

Matrix Total Column

Difference between two columns or rows

Regards,

Yuliana Gu