I'm trying to create a table that looks something like this
I'm having trouble on creating the "Year total" expression. This should be the sum of "Sales" with only "Product" as filtering variable. When I try to do this with set clause it also uses "Quarter", giving the sum for the "Quarter", not the whole dataset. Here's my set clause
Any help on how to achieve something like this?