4 Replies Latest reply: Mar 25, 2015 9:17 AM by Matt N RSS

    Find the Corresponding Date to Max Value

    Matt N

      I am attempting to find the week in which the max sales occurred. The date is needed to feed back into another formula to show the daily trend in the week.

       

      I have the max sales number but have hit a bump in trying to now return the ActivityWeek the amount is associated with.

       

      Max(AGGR(sum(ActSales), ActivityWeek))