Possible? Sorting within a sub-summary on a summary field

[Slater]

Hi All,

Been wrestling with this one ...

I've got a layout that has a sub-summary part, that sorts "Jobs" by the client's "name" and within that sub-summary part shows a summary field "total spent" = "Total" of invoices, ie

BBC....................spent 500.....no. of jobs3

Queen................spent 250.....no. of jobs4

R comes after Q..spent 800.....no. of jobs2

but what i'd like to see is the clients listed by the quantity of spend, ie

R comes after Q..spent 800.....no. of jobs2

BBC....................spent 500.....no. of jobs3

Queen................spent 250.....no. of jobs4

I'm guessing that this isn't possible because the records are collated on the name, and you can't include a summary field in the sub-summary part. Am i right, or is there a cunning work around?!

Many thanks,

Slater

ps apologies if in the wrong section

Edited March 6, 2009 by Guest

[comment]

See if this helps:

http://www.filemaker.com/help/html/find_sort.5.22.html#1029044

[Slater]

See if this helps

Comment, really, i bow down ... you are a saint and i thank you from the bottom of my heart

all the best,

Slater

[comment]

LOL, all this for an RTFM?

[Slater]

LOL, all this for an RTFM?

ah, but you don't know what i did with it .... and your kindness to reply - roll them both together and you've got one very happy camper!

:woohoo: