4 Replies Latest reply: Jun 13, 2012 6:55 AM by Gerard Bakker RSS

    Total over previous years

    Gerard Bakker



      I have a question and I really need some help.


      When I use a table in a bar chart with the columns YEAR, PERIOD and QTY, I want to do the following with one expression:



      YEAR < Max(YEAR)

      then (Total QTY of that Year)

      Else Sum(QTY)


      Only the bar of Max(YEAR) must change when I put a selection on PERIOD.


      My test file is attached.


      Please help me, I think it’s something with the aggr function, but .....