By using this website, you agree to our Terms of Use (click here)
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
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.
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.