AnsweredAssumed Answered

Sorting by SubSummary total value

Question asked by itslike123 on Aug 10, 2018
Latest reply on Aug 11, 2018 by fmpdude

Hello Everyone.

I need to be able to sort my records based on total subsummary less then 2400

 

Example:

 

Record 1:    table::field = 1200

Record 2:    table::field = 600

Record 3:    table::field = 200

Record 4:    table::field = 1200

Record 5:    table::field = 1200

 

Result in the list view that i want to achieve is:

table::field = 1200

table::field = 600

table::field = 200

                   SubSummary= 2000      

table::field = 1200

table::field = 1200

                    SubSummary= 2400      ( it cant be over 2400)

 

I want the records sorted by maximum of 2400 in total ( Finding the best scenario to group records as close as possible to 2400 )

 

At the moment i'm getting subSummary of all records diplayed

Any help is much appreciated

Steve

Outcomes