Forum Discussion
SUBTOTAL in Matrix Visual as Row
Hi,
I am facing an issue calculating a subtotal column. I tried to use CALCULATE SUM with FILTER but it does not really work.
Maybe somebody has a good idea? 🙂
Current Matrix Visual View:
| 2024 | 2025 | 2026 | |
| Apples | 4 | 10 | 23 |
| Bananas | 5 | 67 | 43 |
| Cucumber | 2 | 6 | 3 |
| TOTAL | 11 | 83 | 69 |
Trying to get this view with calculated row:
| 2024 | 2025 | 2026 | |
| Apples | 4 | 10 | 23 |
| Bananas | 5 | 67 | 43 |
| SUBTOTAL FRUITS | 9 | 77 | 66 |
| Cucumber | 2 | 6 | 3 |
| SUBTOTAL VEGETABLES | 2 | 6 | 3 |
| TOTAL | 11 | 83 | 69 |
Appreciate any ideas and feedback.
Kind Regards
tim_001 You could get something like this if you add a column to identify Fruits and Vegetables in your table. Otherwise, you are looking at a disconnected table and a single measure that identifies the row it is in and returns the appropriate calculation.
Hi Greg_Deckler Thanks. So I would make another column that says if "Apple" then "Fruit" and so on. And then I can make a SUMIFS based on that column?
Hi, I added a column and used this formula:
If(containstring(columnname, "X"), "desired", "none")
Now I just moved that in the first order of the matrix visual. So I have the Subtotal as one row and you can expend from there. I think this is the easiest way thanks.
3 Replies
Hi, I added a column and used this formula:
If(containstring(columnname, "X"), "desired", "none")
Now I just moved that in the first order of the matrix visual. So I have the Subtotal as one row and you can expend from there. I think this is the easiest way thanks.
tim_001 You could get something like this if you add a column to identify Fruits and Vegetables in your table. Otherwise, you are looking at a disconnected table and a single measure that identifies the row it is in and returns the appropriate calculation.
Hi Greg_Deckler Thanks. So I would make another column that says if "Apple" then "Fruit" and so on. And then I can make a SUMIFS based on that column?