aggregation in chart on some dimensions

[#1]

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

[luciancotea]

=aggr(TOTAL SUM(Sales), Region, Country)

[#3]

Hi,

I tried this expression but it does not work when I apply filter on Region/Country (select in listbox).

Thanks,

Samir

[#4]

I'm not the best in English, but let's go hehe, I think is like this

SUM ({ < State = > } Sales)

without $