Hi,
Not sure if this does what you need, but the attached xml of the GI was updated as follows:
- Added ZZ to the name as this is a system created GI and I didn’t want to impact the original.
- Changed location to Data Views workspace.
- Added grouping by inventory ID.
- Added ARTran.Qty to results and then sorted by this field descending.
- Results - Used Aggregate Functions to sum, count, average and find max of fields and updated captions to reflect data being displayed. Unchecked the Visibility box for fields which don’t make sense to display when grouped by inventory ID. (ie. sales order number, customer ID, etc.)
The end result displays one line per inventory item sorted by quantity sold from highest to lowest. All of the original parameters are still available to filter by date, item class, etc.
If you needed to drill into the original sales orders or wanted to see the detail in the GI, this version will not accomplish that….
Please let me know if you have any questions. Hope this helps!