Sorting by an Aggregate - Acumatica Report Designer https://www.augforums.com/forums/acumatica-report-designer/sorting-by-an-aggregate/ Acumatica User Group Forums en-US Tue, 06 Oct 2026 15:37:14 +0000 wpForo 60 RE: Sorting by an Aggregate https://www.augforums.com/forums/acumatica-report-designer/sorting-by-an-aggregate/#post-3337 Fri, 28 Dec 2018 05:11:51 +0000 That's a tough one with reports--the only way I can think of is if you built a GI and then you can sort the aggregate field by running the GI and doing a Descending sort on the aggregate column.

]]> Acumatica Report Designer AhmedBahar https://www.augforums.com/forums/acumatica-report-designer/sorting-by-an-aggregate/#post-3337 RE: Sorting by an Aggregate https://www.augforums.com/forums/acumatica-report-designer/sorting-by-an-aggregate/#post-3175 Thu, 06 Dec 2018 23:01:45 +0000 I wish there was a way to do this, but if there is I don't know how.

The problem is that you can't choose another field in the SortOrder field. You can only sort on the group fields themselves.

]]> Acumatica Report Designer Tim Rodman https://www.augforums.com/forums/acumatica-report-designer/sorting-by-an-aggregate/#post-3175 Sorting by an Aggregate https://www.augforums.com/forums/acumatica-report-designer/sorting-by-an-aggregate/#post-3095 Wed, 28 Nov 2018 06:36:31 +0000 I am trying to design a Sales Report that will sum the total sales per customer for a selected period.

That's the easy part! I then want to sort the Customers by total sales in descending order. 

I thought this would be a simple and common report requirement but I cannot get a build schema to do this successfully.

Can someone please advise the best way to achieve this sorting or point me towards an existing report which does similar?

Cheers

Wayne

 

]]> Acumatica Report Designer Wayne Keltie https://www.augforums.com/forums/acumatica-report-designer/sorting-by-an-aggregate/#post-3095