6 Replies Latest reply: Feb 22, 2012 9:00 AM by jagan mohan rao appala RSS

    Help with SET-analysis - values "year to period"

      Hi,

       

      Have a list box (YearMonth) with reporting periods, 201109, 201110, 201111, 201112 etc. YearMonth have a logical connection to the listboxes "Year" and "Month" (When 201109 i choosen i "YearMonth", only "Year" 2011 and "Month" 09 are available (but not choosen).

       

      The user have to choose ONE reporting period (YearMonth) i e 201109.

       

      I would then like to calculate the monthly "Sales" and the year to period "Sales". Monthly Sales works fine with just : =Sum(Sales)

       

      How do I calculate the Sales for period 1 to period 9?

       

      Thanks in advance