Ordering a Report by a Count

[lkerr]

I tried to search for this, because I'm sure it's been answered, but the google search didn't produce anything useful. Any help would be appreciated.

I have a report with the following:

Group 1: {year}
Group 2: {Client Name}
Group 3: {Product}, {Distinct Count, Sale ID}
Detail (suppressed): {Sale ID}

The manager I'm doing the report for wants the report sorted by the {Client Name} with the highest {Distinct Count, Sale ID} to the lowest for a certain {Product}.

How on earth ... is it even possible? Thanks in advance for your help!

 

[lbass]

After right clicking on and inserting a distinctcount on {saleID} at the Product group level, go to report->group sort and select "All"->distinctcount of saleID->descending.

-LB

 

[lkerr]

Never mind ... the user changed his needs/wants and made it much easier for me. Thanks anyhow.

 

[lkerr]

lbass -

That's exactly what I ended up doing. He originally wanted it sorted by only a certain product, which was driving me batty. But, since he wanted it sorted by ALL products, he made my life ever so much easier.