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

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

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!!

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, 200520 yr by Guest