Calculate difference between columns in matrix

[Anonymous]

Hi,

I created a matrix showing the percentage of column total of some column in my table. I want to compare the percentage between 2 chosen columns in the matrix (here: Auchan and Carrefour).

So, you see 12,97% in Auchan and 15,42% in Carrefour. Hence, Carrefour is 19% higher than Auchan and the number I'd like to show then is 119 (in a third column)

How can I do that?

[v-yulgu-msft]

Hi @Anonymous,

Here is a similar example for your reference:

Difference between 2 columns in a Matrix Table

Best regards,

Yuliana Gu

[Anonymous]

@v-yulgu-msft: how does this work when you want to compare 2 categories and not 2 periods? I can't work it out...

[Anonymous]

I know, but that doesn't solve my problem. Mine is not about periods AND it is about a column as percentage of column total.