Quote Originally Posted by p45cal View Post
I think I've understood the problem; I'm just asking what you want in slightly different circumstances (and if such circumstances ever happen). For example here are 4 rows all with the same FullName, Type and Date:

2024-05-28_121027.jpg

which you'd want summarising something like:

2024-05-28_121143.jpg

but look carefully at the classification column of the source data, 2 rows are ABC and two rows ABG. So what do you want to appear in the classification column of the summary? It's not a case of them being static or agnostic, it's what do you want to see?
I missed that p45Cal; so that'll also need to be a range to filter on. Great pickup. The classification needs to be considered in the summation given there could be a difference between them.
So it'll be a sum (AmountLocal) based on range criteria {classification, FullName, Type, Date}
Cheers