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

    Date of the max daily sales for a date range

    Jen Starr



      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.






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