3 Replies Latest reply on Jul 31, 2018 2:46 PM by Kathryn Mclaren

    Want to create a rolling 12 month viz for sales with comparatives to the previous 12 months

    Kathryn Mclaren

      I want to be able to compare the current a rolling 12 months of sales and compare it to the rolling 12 months of sales for the prior period.  I know how to do it for the current period using this formula:

      IF (DATEDIFF('month',[Invoice Date],TODAY()))<=12

      THEN [Net  Adj. Extended Sale ($)]

      ELSE null

      END

       

      But unsure how to do it for the prior period.  Any help would be appreciated.

       

      Kathryn