12 Replies Latest reply: Mar 20, 2017 2:03 PM by Deepak Tibhe RSS

    > 12 month value aggregation in one column

    Deepak Tibhe

      I have month year column.

      I need to aggregate value for all month year having value > 12 month, I am using dimension as per below please suggest.

       

      =If(Date(AR_CustomerLedger.MonthYear, 'MMM-YYYY') >= Date(AddMonths(Today(),-11), 'MMM-YYYY'), Date(AR_CustomerLedger.MonthYear, 'MMM-YYYY'), '> 1 Year')