Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 10, 2016 at 08:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded