5 Replies Latest reply: Jul 22, 2011 12:35 AM by Ashish Kumar RSS

    How to make a simple Year To Date ?


      I' three fields : "Year", "Month" and "Value"

      I display a table :

      Year, Month as dimensions, Sum(Value) as expression.

      1) What is the easiest way to add another expression which make a Year to date (i.e sum of Value since the beginnig of the year).

      2) Same question using Set Analysis. To be precise, if the user click on a month, the new expressions must continue to display the YTD (even if some months are excluded).

      I've put an example in attachment.

      P.S : I work with the V9 version SR2