|Simple question - cannot find answer - Sort by Group Totals [message #1803692]
||Wed, 06 March 2019 21:34
| Jeff Stouse
Registered: March 2018
Simple report that pulls in rows of data with a field that contains dollars. The report is grouped by client and sub-totaled by same. Each client has a group sub-total of the dollar column. |
I need to sort the report in descending order by the sum of each group. I can get the sum to appear, but when I try to add a sort, there is no way to create the sub total, as the aggregate is in the report definition, separately.
I cannot find a function to create the subtotal in the grouping dialog.
What simple concept am I missing?
Many thanks in advance!
Two weeks and no responses - can anybody point me in the right direction? I really need to come up with a solution - otherwise I have to look for a new reporting tool.
Will this require programming to set up? I need some guidance.
[Updated on: Sat, 23 March 2019 19:55]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.02649 seconds