Forum Discussion
Adding a new column to a matrix visual based on calculation
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.
Not a calculated column.
