13 Replies Latest reply: Dec 21, 2017 3:31 PM by Sunny Talwar RSS

    Accumulation Pivot

    Antonio Forino

      I would like to have the sum of last 12 month based on the maximum "Invoice_date" done on the selection.

       

      How this can be build?

       

      This is the formula for sales based on the selection (imagine May - 2017)

      =Sum(ExtendedUSD)

       

      Which shuold be the formula to retrieve the last 12 month sales ?