Count

[CARLEENHOP]

Hi

Using Crystal v11. I want to get a total which i need to to a distinct count on a field where another field = a certain criteria.

E.g. if Sord.typ = 1 then distinct count sord.num. I am currently grouping by a couple of different levels, plus sord.num and sord.typ. I need to display my data together. E.g. a total of sord.typ 1 and a total of sord.typ 2 in the same record.

I hope this is enough to help.

Thanks

 

[CARLEENHOP]

I think I may have just worked this out by using a running total with a formula. Does that sound correct?

Thanks