Added columns to pivot table stop running totals

[miwnr]

I would like to re-post my original post with a better example for the issues I am having.

When I use the running total with these columns shown, the running total works.

Item name	Item No.	Date of Movement	Sum of Quantity	Running Total that works
Frami S Xlife universal panel 3'-0"x6'-0"	588808500	2/6/2018	4	4
		3/5/2018	3	7
		3/29/2018	(7)	0
Frami S Xlife universal panel 3'-0"x9'-0"	588807500	2/6/2018	4	4
		3/5/2018	3	7
		3/29/2018	(7)	0
Super plate 15.0	581966000	2/6/2018	450	450
		3/5/2018	30	480

<colgroup><col><col span="2"><col><col></colgroup><tbody>
</tbody>

If I add "Type of Transaction" and "Number" columns, the running total no longer works. Can someone let me know what is happening. Any suggestion to fix this would very much appreciated. Thanks for the help.

Item name	Item No.	Type of Transaction	Number	Date of Movement	Sum of Quantity	Running Total NOT Working
Frami S Xlife universal panel 3'-0"x6'-0"	588808500	Delivery	412249997	2/6/2018	4	4
			412250407	3/5/2018	3	3
		Return	412421026	3/29/2018	(7)	(7)
Frami S Xlife universal panel 3'-0"x9'-0"	588807500	Delivery	412249997	2/6/2018	4	4
			412250407	3/5/2018	3	3
		Return	412421026	3/29/2018	(7)	(7)
Super plate 15.0	581966000	Delivery	412249997	2/6/2018	450	450
			412250407	3/5/2018	30	30

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

<colgroup><col><col span="2"><col><col></colgroup><tbody>
</tbody>