3 Replies Latest reply: Dec 3, 2015 2:58 PM by Massimo Grossi RSS

    Set Analysis


      how to show Last month sales i am getting syntax problum please help me

        • Re: Set Analysis
          Sunny Talwar

          Your Month Year field is text field and not Dual (Date) Field. Make these changes in the script and rerun:


          LOAD MonthName(Date#([Month&Year], 'MMM YYYY')) as MonthYear,




          (ooxml, embedded labels, table is Sheet1);


          Once you have done that, try this expression:


          =Sum({<MonthYear= {"$(=MonthName(AddMonths(Max(MonthYear), -1)))"}>} Sales)

          • Re: Set Analysis
            Manish Kachhia

            Current Month

            =num(sum({<[Month Year]= {"$(=Date(Max(Date#([Month Year], 'MMM YYYY')),'MMM YYYY'))"} >}Sales))


            Last Month

            =num(sum({<[Month Year]= {"$(=Date(Max(AddMonths(Date#([Month Year], 'MMM YYYY'),-1)),'MMM YYYY'))"} >}Sales))

            • Re: Set Analysis
              Massimo Grossi

              Count({$ <[Month Year]={"$(=(Date(Max(AddMonths(Date#([Month Year], 'MMM YYYY'),-1)), 'MMM YYYY')))"}>} [Month Year])