Is it possible to show the Grand Total for the last column only?
The other columns cannot be added.
I can either work with a table or matrix.
I'm trying with:
Measure = IF(ISFILTERED('Table'[Category]);SUM([Quant.]))
This hides the grand total but then it doesn't summarize rows by Category, ie, it shows all the items.
So all rows get a 1 for the measure above.