Last PO ID and Vendor

[LOUM]

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

[PRIT AMRIT]

I 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])

[LOUM]

 8)

Worked great, ty.