I have a listing that can be sorted in a number of ways.
I have used the sub-summary facility to operate when sorted on field A, with a summary field (Counting the number of Surnames) giving the correct figure in each grouping.
I have then executed a sort on a different field, using another sub summary grouping. That works fine. But the same Summary field is now showing total incorrect figures. I can't even guess at what they are calculating.
Has anyone any idea why the summary field should work correctly in one sort and not in another - even though they are technically counting the same object field?