AnsweredAssumed Answered

Sorting (Sub-sorting)

Question asked by BrianClemens on Aug 31, 2012
Latest reply on Aug 31, 2012 by BrianClemens


Sorting (Sub-sorting)


So I have one screen that sorts based on a number that is generated when a date is in a certain field.

On Order: shipped date is blank

Inventory: shipped date is filled in, sold date is blank

Sold: Sold date has a value.  I sort based on these fields as shown on the screen shot.

How can I further break downthe "Sold" units so that they are grouped and summarized by year?

I'm thinking that I would need a field to generate the year from the sold date field.  And then do a summary field based on that?  I only want to do this for the Sold grouping, I'd rather not have it separate the Inventory into separate years when they have inventory from multiple years.