Skip to Content
0

How can I sort on a field created in Running Totals Field

Nov 09, 2016 at 06:53 PM

20

avatar image
Former Member

Hello,

I created a report with a field summing all the maintenance cost for each unit (used the "Running Totals Field". I would like to sort the units based on highest to lowest total maintenance cost. I looked in the "Record Sort Expert" but the field I created in the Running Totals wasn't listed. Any help would be appreciated.

Thank you.

Helen

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Abhilash Kumar
Nov 10, 2016 at 08:00 AM
0

Hi Helen,

1. Insert a summary instead of using a Running Total.

To do this, go to the Insert Summary option > Choose the 'Cost' field as the Field to Summarize > Choose 'Sum' as the Operation > Under 'Summary Location', choose 'Group #1'.

2. Go to the 'Group Sort Expert' (Report Menu > Group Sort Expert).

'For this group sort', choose 'All'.

Select the Summary field as 'Based on' and sort in Descending order.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded