Different logic for every cell

[#1]

Hi,

I have to develop a dashboard where every cell is having a different logic to fetch the values

Please refer the example below -

How can i implement this in the expressions ?

[Clever_Anjos]

You can use Columno() and rowno() as reference

Pick(Columno(),

   Rangesum(

               If(Rowno() = 1, [Logic1]),

               If(Rowno() = 2, [Logic2]),

               If(Rowno() = 3, [Logic3]),

  ),

  Rangesum(

               If(Rowno() = 1, [Logic A]),

               If(Rowno() = 2, [LogicB]),

               If(Rowno() = 3, [LogicC])

)

)

[marcus_sommer]

You need to apply a pick(match()) combination like:

pick(match(Dimension, 'Dim1', 'Dim2', ...),

     Expr1,

     Expr2,

     ...)

- Marcus