14 Replies Latest reply: Sep 15, 2014 10:14 AM by anbu cheliyan RSS

    Help needed on Expression

      Hi All,

       

      I have to get total based on the selected Month and Year.

      My table as below

      Sales    Date

      987    1/1/2014

      776    2/1/2013

      654    1/1/2012

      656    11/2/2011

      987    12/2/2011

      776    11/5/2011

      654    11/2/2011

      656    12/2/2014

      987    11/3/2014

      776    1/4/2014

      654    11/5/2014

      656    1/4/2014

      656    11/5/2014

      776    11/2/2014

      654    12/2/2014

      656    11/3/2014

      987    1/4/2014

      776    11/5/2014

      654    1/4/2014

      656    11/5/2014

      987    1/1/2014

      776    2/1/2014

      654    1/1/2014

       

      Conditions to get total sales as below:

       

      1. Default total if there is no selection of Year & Month (Default to Current year, Current month)

      2. If Year only selected and that is LT current year default total based on DEC & Selected Year.

      3. If Year only selected and that is Current year default total to Current year, Current month

      4. If Year, Month selected - total of that Year and Month.

      5. If Day only selected, default total to Current year, Current month

       

      Thanks in advance for help.

       

      Regards,

      Lakshmi.