Need Excel 2010 pivot table with running totals that reset to baseline

I have a monthly report to produce for my department’s requisitions. We are able to order up to $250k of items without requiring administrative approval (per vendor, either individually or in aggregate:
i.e., one $100k purchase or ten $10k purchases would not require administrative approval; a single $260k order would require further approval, as would this scenario: Two $100k orders are placed in Sept. A $40k order is placed in October. A $30k order placed in November would put this vendor over the $250k limit, so that order would require administrative approval)

As the academic year progresses, if we reach the $250k level, and administration approves the item(s), the “baseline” is then reset to zero, and we start again accumulating towards the next $250k ceiling.

I would like to have a report that shows the YTD accumulations for each vendor (which a running total takes care of), BUT I need the report to “reset” once we’ve gotten administrative approval at the $250k+ level. I’ve done an exhaustive search on the internet and have not found a solution.

In the pivot table, D9 should be zero

Yes, D10 should be $4564

<<If you would like a solution that requires you to sort the pivot table by Vendor Name, and then by Requisition, I might be able to help you>>
Yes, thank you. (sorry for the delay in replying, I haven't been able to log into the forum for a while)

This looks really good, thanks so much for troubleshooting the s/s.
Have a great weekend!