How to sort from a sum of related data

Hi there,

I’m trying to sort data from a related sum.

It goes like this :

Repeating Group of allocations > allocation’s project > project’s allocations (list) > each item amount > sum.

I’m trying to sort this allocation RG from the total of their parent project allocations’ amount sum.

Do you know a way of building this?

Maybe using List shifter? cc @keith

Thank you :slight_smile:

Yes, if you can construct the numeric list you want to sort on, List Shifter or Floppy can do that sort (the interface to either is somewhat different).

There are some recent discussions of this type of sorting in the List Shifter thread. For a discussion of how Floppy can do this, see:

NOTE TO SELF: Floppy’s Count Fields/Sort action currently can construct a “sort by” list by counting the number of entries in some field, but it might be useful (if the field in question is numeric) to add options to take not the count of entries, but their sum/min/max/avg as an option…