Expand my Community achievements bar.

The Community Advisors application is now OPEN for the second class of 2024. Apply to become a part of this exclusive program!

Sort a report based on a Group Total instead of individual row values.

Avatar

Level 3

2/14/22

Reference - Case Number 00297963


https://amazonaccounting.my.workfront.com/report/61bbc0e1004a4c432da4912d216478a0/detail


The above issue report is group by Project Name and provides a total of a custom field called "Total Annual Support" which is a custom calculated field. I would like to sort the report so that the project with the highest Total Annual Support value is at the top of the report.


Currently, the only possible way I see is to run the report and manually click on the header name for "Total Annual Support" but the system sorts based on each individual issue value and not the total at the project grouping.


It would be great if there was a switch to indicate whether to sort on the individual issue value or the group total value.


Thanks,

James