Hello,
I am pulling in the follwing data to my List report.
PO ID , Date, Vendor, Item #, Description, UOM, cOST, Quantity and Department.
I have it rolling up as such.
Item Number, Description, UOM and Quantity
Example: 12345, Toilet Paper, Case, 1569
I filter on the date and department. Report section by department.
That is the rollup, I want to add last PO ID, VENDOR AND COST. I tried using;
Maximum ([PO ID] for [Item Number]) but it pulls the last regardless of the department...
I want it to look like this:
Item Number, Description, Uom, Quantity, Last PO Id, Last Cost, Last Vendor Purchased from
12345, Toilet Paper, Case, 1569, P-36596, 36.95, Nasa
Any assistance would be great
QuoteI tried using;
Maximum ([PO ID] for [Item Number]) but it pulls the last regardless of the department...
Try like this and see if it helps?
Maximum ([PO ID] for [Item Number],[Department])
8)
Worked great, ty.