Date of the max daily sales for a date range

[Anonymous]

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))

[settu_periasamy]

Hi Jen,

Try This,

=FirstSortedValue(Transaction_Date,-aggr(sum({<TranGroup={Rolling},TranRange = {'Rolling 12 Mths'},

Invoice_Status = {Sale},Order_Sequence = {Trial,'Full Initial Sub'}>}

Invoice_Amount),Transaction_Date))