I have an internal table with about 50,000 records. I need to group these (sort) based on 4 fields and then provide the count for each combination of the 4 fields.
For eg, if I have 3 records in the table which have the same values for all the 4 fields - say A,B,C,D, then the count is to be taken as 3 for that combination.
So my output will be
A B C D - COUNT -4 and so on.
I am looking for a efficient technique (good performance) to meet the above requirements given without too many loops ie with Please advise if you have a good method.
Thanks as always!