Crystal XI - Calculating count once per category

[pndMaster]

Hello,
I have below data and i would like to count the data by category and if client has more category then he needs to be counted only in one category according to the order

clientid category id catg date
123 low 1/1/2015
123 mid 3/1/2015
777 mid 5/1/2015
999 mid 7/1/2015
999 high 5/1/2015
345 high 4/1/2015
Total Unique Clients is 4
the output data should be

category id client count
low 1
mid 2
high 1

If client has low then he will be added in low category and if client has mid and high then he will be counted in mid and so on.

I appreciate the guidance

Regards
Harris

 

[SkipVought]

pndMaster, over the past 2 1/2 years you have started 9 threads where various members have posted replies. Yet you have not replied in any way: good, bad or indifferent.

If you browsed any of the forums here at Tek-Tips, you'll notice that the original posters' replies are vital to other members, for identifying what answere were Great Posts. You, no doubt, have also seen the little purple stars. This is all part of what makes Tek-Tips such a great site.

So I hope you'll help us make your threads more meaningful with appropriate replies.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[pndMaster]

Will do @Skip

Regards