1 Reply Latest reply: Dec 10, 2015 10:18 PM by Settu Periyasamy RSS

    Date of the max daily sales for a date range

    Jen Starr

      Hello,

       

      I am looking to display the date that the max daily sales occurred on during a rolling 12 month period.  The expression below works very nicely and give me the amount for the day that had the most sales, now I need to display the date.

       

      Any help would be greatly appreciated.

       

      Thanks,

      Jen

       

       

      =Max(aggr(sum({<TranGroup={Rolling},TranRange = {'Rolling 12 Mths'}, Invoice_Status = {Sale},Order_Sequence = {Trial,'Full Initial Sub'}>} Invoice_Amount),Transaction_Date))