Sort Summaries Descending

[LaRetta]

Maybe I just can't find a reference to it, but I have a columnar list layout with leading part based upon product. There is no body; only Product and summaries. Of course it needs to sort first by Product. I then select 'sort by summary field' and select Total Sales. But it won't allow me to sort descending!!!

Either I'm blind or missing something very basic here or ... ?

Sales Manager wants to see all Dollar summaries descending and I couldn't even do it! I'll be switching to a different process soon but until then, he needs these regular reports. Help please!!

LaRetta

[comment]

What happens if you first select sort by Product, descending, then reorder based on Total Sales?

[LaRetta]

Yes, that's exactly what I do. It sorts by summary Sales but Ascending. And I see no way to specify sort on the summary field.

Specifically: The Product is in the right-pane sort box. Instead of displaying an ascending or descending graphic, it shows a strange page graphic. Selecting the Product then accesses the lower section which shows ascending. Reorder based upon Summary field is selected. If I click 'Specify', it shows sTotalSales, I say OK. End of options. End of story. Sorts ascending. If I attempt to click descending, the Product changes to descending!

Sales Manager is spitting bricks! I just made excuse and left early.

It must be something simple but I just don't see it!!

[LaRetta]

OMG!

Never mind!

I, uh, thought Product must be sorted ascending for the summary to work correctly. And I couldn't see the page graphic. But with magnifying glass, I see it! And, AS YOU SUGGESTED, I changed it FIRST to descending.

: ... long week ...

Edited August 12, 2005 by Guest