table with different row formulas in column

[#1]

HI

need to show an excel like table where I have some items in rows that require different formulas.

Like:

Order	Label	Value
1	KPI1	sum(a)
2	KPI2	sum(b)
...

I have experimented with conditional expressions in a straight table like

     Dimension = Label

     Expression 1: =sum(a) with condition Order=1

     Expression 2: =sum(b) with condition Order=2

and using pick

     Expression 1: =pick(Order, sum(a), sum(b)

but both methods did not work.

Juerg

[#2]

Hi,

Try the below expression's:

Exp 1:

IF(Order=1, sum(a), IF( Order = 2,sum(b)))

Exp 2:

IF(Order=1, sum(a),sum(b))

Regards,

Desmortes

[#3]

The evaluation of Order seems not to happen on the row level. therefore the formula works only if a single Order value is selected?