Audioslaver
New Member
- Joined
- Aug 13, 2013
- Messages
- 3
Hi
I am building a report to show my team of buyers which Purchase orders are overdue under each persons name.
The pivot table is pulling from a table of "unprocessed" PO lines. Consolidating the data first by buyer and then PO number. I need to filter due date "= or < current date" and then have a subtotal of overdue PO's per buyer as a metric. I would also like to add the or remove the item lines without the report changing the subtotal calculation away from the unique PO count.
I have tried to get this done and need help with the subtotal of the unique PO number count.
https://drive.google.com/open?id=1CsO9mPuKFqZERar01zh1rpap_vK845El
I am building a report to show my team of buyers which Purchase orders are overdue under each persons name.
The pivot table is pulling from a table of "unprocessed" PO lines. Consolidating the data first by buyer and then PO number. I need to filter due date "= or < current date" and then have a subtotal of overdue PO's per buyer as a metric. I would also like to add the or remove the item lines without the report changing the subtotal calculation away from the unique PO count.
I have tried to get this done and need help with the subtotal of the unique PO number count.
https://drive.google.com/open?id=1CsO9mPuKFqZERar01zh1rpap_vK845El