SUM Indicator1 when Dim1=ValueX and Dim2=ValueY

[#1]

Hello

How can I a set up an expression to SUM Indicator1 when Dimension 1 has a certain value and a Dimension 2 another particular value

[johnw]

sum({<Dimension1={'Some Value'},Dimension2={'Another Value'}>} Indicator1)

[#3 · Accepted solution]

Hi Armas

You could use set analysis in an expression such as

=Sum({$<Dim1={ValueX},Dim2={ValueY}>}Indicator1)

This will sum the values of Indicator1 only where DIM1=ValueX and DIM2=ValueY.

E.G.

Indicator1	Dim1	Dim2
25	20	60
45	30	50
100	30	50
24	40	50
24	45	76

Sum({$<Dim1={30},Dim2={50}>}Indicator1)

gives the answer 145 i.e. 100 + 45, the two values of indicator1 where Dim1=30 and Dim2=50.

Hope that helps

Steve