3 Replies Latest reply: Jul 16, 2011 4:37 PM by Liesbeth Mulder RSS

    using the Fieldname to retrieve fieldvalue

      I have a fields named 'A' untill 'Z'. In my chart the dimension is $FieldNo and I want one expression so that when $FieldNo = 1 -> sum(A) ; $FieldNo=2 -> sum(B), etc. I tried making an expression while loading, being 'sum(A)', etc, but that works just for one single value.

      I want it to work what in Excel the function INDIRECT() does!