Forum Discussion
Calculate difference between columns in matrix
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?
3 Replies
Hi Anonymous,
Here is a similar example for your reference:
Difference between 2 columns in a Matrix Table
Best regards,
Yuliana Gu
v-yulgu-msft: how does this work when you want to compare 2 categories and not 2 periods? I can't work it out...
