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.