9 Replies Latest reply: Dec 15, 2011 11:15 AM by Lucian Cotea RSS

    Set expression - question

      Hi,

       

      I have a problem with a reporting- requirement that keeps coming up in different projects, so I thought maybe one of you would have a great idea, how to solve it...

       

      The problem is I need to dynamically compare to monthly values in a table, that also contains the dimension month (see screenshot - 3rd column).

      I can't use the above() - function because the previous month is not always displayed in the table (i.e. there is no October in the sample graph)

       

      I could get it to work for with hard - coded month with this formula (2nd expression):  sum({$<Month={1}>} Total Value)

       

      It didn't work when I tried to reference the month of the current row with something like this (3rd expression): sum({$<Month={"$(=only(Month)-1)"}>} Total Value)

      problem_set.png

       

      Please find attached a qvw that illustrates the problem. I hope someone can give me a hint, how to handle this.

       

      Thanks in Advance!

       

      Cheers,

      Gerald