Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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
= Sum({$<Year={Year(Quarter)},Quarter=>})
Any help on how to achieve something like this?
You can use the TOTAL keyword as follows:
sum(TOTAL <Product> Sales)
Jonathan