Sum dimension's value in a bar chart

[#1]

Hi,

I have a bar chart with a dimension country and in my expression i want to sum 2 country on my dimension.

I try this :

IF(DimCountry="Marseille",

Sum( {$<DimCountry = {“Marseille”,”Aix en Provence”}>} Montant ),

Sum(Montant)

)

but that doesn't work...

How have to I make ?

Thanks a lot.

[swuehl · Accepted solution]

You still get only the value for Marseille?

I believe you need to use a total qualifier in your sum, where you want to retrieve values for dimension values outside your current (Marseille) dimension scope:

IF(DimCountry="Marseille",

Sum(total {$<DimCountry = {“Marseille”,”Aix en Provence”}>} Montant ),

Sum(Montant)

)

[#3]

Thanks  a lot !!!