4 Replies Latest reply: Apr 14, 2011 9:35 AM by stoffelssj RSS

    Last value of column(x) group by dimension

    stoffelssj

      In the picture below i want the following output as my result in the 7e column:

      Arnhem: 8 (Delta)
      Rotterdam: 1 (Delta)

      I used the following expression in the 8e column: COUNT(TOTAL<Region>Actual-Budget)
      In the 7e column I used this expression in the function 'FieldValue' and looks like this:
      FieldValue('Delta',Count(TOTAL<Region>Actual-Budget))

      Now I known that 'FieldValue' looks after the LOAD order and not on the value order of this chart.

      My question is what for expression is needed to give me the right output??

       

      error loading image