Max Value Based on Conditions

Hi Gav,

You can create a pivot table from your data (see attached).

the "auto", "dngitr30" and the "in" are in the page section of the pivot.
Your "date" and your "values" on the "Row" section of the pivot.
The "Sum of value" (must be formated as numeric on the source sheet) in your data section.

On the field configuration Under Top 10 AutoShow select 3 and sort the field descending.

As new data is inserted you will see the totals change automatically. (New dates also). You just need to refresh the pivot. (click the button).