calculate total of filter

[bartwelvaarts]

hello,

I would like to calculate the total of a column but based on the filters i select.

F.e. If i select 2021 en product 'x' i want the total calculated on every row of the selection i made.

If i use total now then it calcutes it based on every row of every product and every year. I attached an example below:

I hope someone has a solution! thanks in advance

[Or]

Using the 'total' qualifier in an aggregation function tells it to ignore dimensions. It won't ignore your selections (that would be the 'ALL' qualifier). I'd suggest checking your data to see why you aren't getting the expected results.