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

    Total over previous years

    Gerard Bakker

      Hello,

       

      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:

       

      If

      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 .....