Using subtraction with a running total

[mellerbeck]

So I have a pivot table

Quantity Limit        PO #     Received Qty Totals     Balance Remaining

333,492                    1          46,669                        286,823

                               2          126,673                       160,150

                               3          46,669                         113,981

And I'm try to calculte the Balance Remaining Which is basically the running total of Quantity Limit - Received Qty Totals

I've tried

RangeSum(-[Received Qty Totals], Above([Balance Remaining]))

But so far no dice, any help would be much appreciated.

Thanks,

Michael

[spividori]

No problem, we all help each other. Thank you.

Regards.