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.



      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?