Outstanding balance formula in Pivot

[Briggs11]

Hi everyone, my first post on here, so please be kind. I have a list of invoices raised and alongside each which Purchase Order they refer to. In a Pivot I can see the total invoices raised against each P.O, but I am struggling to show the outstanding value of the P.O. The list is constantly updated so the Pivot area constantly increases. Hope I have explained this well enough. Thank you in advance.

 

[Briggs11]

Hi everyone, my first post on here, so please be kind. I have a list of invoices raised and alongside each which Purchase Order they refer to. In a Pivot I can see the total invoices raised against each P.O, but I am struggling to show the outstanding value of the P.O. The list is constantly updated so the Pivot area constantly increases. Hope I have explained this well enough. Thank you in advance.

Anyone? ?