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

    Set Analysis

    abc a

      Hi,

      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,

               Sales

          FROM

          [USA.xlsx]

          (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])

               

              1.png