Adding a new column to a matrix visual based on calculation

[psztrtbr]

Hi!

I have the following data table:

Categories	Product	Amount
ALL	A	3
ALL	B	2
ALL	C	10
ALL	A	7
ALL	B	13
Category1	A	2
Category2	B	3
Category3	C	5
Category1	B	3
Category2	A	2
Category3	C	1

I want to make a matrix table out of this in the following format:

Product	Category1	Category2	Category3	ALL minus EVERY CATEGORY	Total
A	2	2	0	10-2-2=6	10
B	3	3	0	15-3-3=9	15
C	0	0	6	10-6 = 4	10
Total	5	5	6	35-5-5-6 = 19	35

From Category1 to Category3 it is easily done, but i'm having a hard time figuring out how to do the calculated column.

[lbendlin · Accepted solution]

Not a calculated column.

[psztrtbr]

If i put this measure in my matrix, the measure gets calculated for every existing column in the matrix. Is there a way around this?

[lbendlin]

You are already skirting by one of the UX rules (don't repeat data in the same visual). I would recommend you use separate visuals.