You can add more group by fields. So, you can add itemid, admin, warehouse and cateogry in the group by field. Category section should be placed in the details rows section and use the sum function for onhand and inprocess fields.
You can add more group by fields. So, you can add itemid, admin, warehouse and cateogry in the group by field. Category section should be placed in the details rows section and use the sum function for onhand and inprocess fields.