11 Replies Latest reply: Nov 25, 2016 7:55 AM by Nithyakala R RSS

    Previous Month for Current Year

    scotly victor

      I wanted to show 2 line chart

      1.current year current month

      2.current year previous month.

       

      Dimension:Month

      My current Year current month expression is

       

      sum({<type={'Order'},FiscalYear={$(=max(FiscalYear))}>} Sales) (works fine)


      My current Year previous month expression is


      =(above(Sum({<type={'Order'},FiscalYear={$(=max(FiscalYear))}>}Sales ))) (issue)



      If I use above expression till may (right to left) I am getting precise value ,however  apr is null,


      Can any one help me?