I am then displaying the numbers in the following table:
My expression gives the wrong values for cat1 and cat2. However, when I choose only one of the categories using a filter pane it comes out right. Why does not my expression filter by cat1 and cat2 directely in the table?
Thanks @sunny_talwar Sunny. I am unfortunately getting an error when trying to use your measure. For me it looked like Aggr was to be placed one parenthesis further up, but I can't get it to work then either.
My data is too sensitive to be shared @nisha_rai , but thanks for wanting to help 🙂