Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a straight table with 3 dimensions, lets say Region, Country, State and a single expression SUM(Sales). I want to do the SUM(Sales) based only on Region and Country but not on State. Is it possible to do this ? What is the expression that i should use ? I tried the following set analysis but it is not working -
SUM
(
{$ < State = > } Sales
)
Thanks,
Samir
=aggr(TOTAL SUM(Sales), Region, Country)
Hi,
I tried this expression but it does not work when I apply filter on Region/Country (select in listbox).
Thanks,
Samir
I'm not the best in English, but let's go hehe, I think is like this
SUM ({ < State = > } Sales)
without $