AnsweredAssumed Answered

Tally and list unique values from related field

Question asked by RyanBuckley on Aug 28, 2014
Latest reply on Sep 3, 2014 by RyanBuckley


Tally and list unique values from related field


     I have a table "Images", which has a child table "Prints" containing all information on printed versions of each particular image.

     Each print has a Size field.

     From the Images table, I want to be able to show a list of all sizes of any given print and the quantities of each for that image.

     Currently i have a calculation field in "Images" with List ( Prints::Print Size ), which gives me all the information I want, but not how I would like to see it. For example, this method lists the images like so:

     8 x 10

     11 x 14

     11 x 14

     11 x 14

     16 x 20
     16 x 20
     20 x 24

     But what I'm trying to achieve is:
     8 x 10 (1)

     11 x 14 (3)

     16 x 20 (2)
     20 x 24 (1)

     I've played around with the "sum the reciprocal" technique, but haven't been able to find a way to make it work.

     Any suggestions would be greatly appreciated!