5 Replies Latest reply: Aug 11, 2012 7:30 PM by Michael Solomovich RSS

    Sum from January to selected month

      Hi,

       

      I have data as shown below:       

       

      YearMonthSales
      2000January10
      2000February10
      2000March10
      2000April10
      2000May10
      2000June10
      2000July10
      2000August10
      2000September10
      2000October10
      2000November10
      2000December10
      2001January20
      2001February20
      2001March20
      2001April20
      2001May20
      2001June20
      2001July20
      2001August20
      2001September20
      2001October20
      2001November20
      2001December20

       

       

      I need to do Sum of Sales between January of Selected year till Selected Month of that Year  .for eg In above scenario if I select Year =2000(listbox) and Month=March(listbox) then expression should show sum= 30.