I assume you have the data to translate the Cashier Number to a name?
So a 2 column summary with name in the first column and transaction code in the second (sorted) would be close? Especially if the repeating values in the first column were suppressed? (I assume that the output format requirement is part of your concern. Indeed it may be your major concern.)
Could you then simply use a filter to select only the codes you require and apply the count to transaction code field?
Failing that, and depending upon the version you have (I can't remember if we have covered that in earlier posts) perhaps something in the 'matching' menu would be usable.
I will be happy to play around with some sample data if it would help.
All the best.
Here's what I have for data:
A Cashier Number (numeric field)
A Transaction Code (numeric field)
Transaction Codes range from 5000-6000.
Does anyone know how to create a summary that will show fields like this:
of 5000 Transactions
of 5001 Transactions
and so on.....
Thanks for any ideas,