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.
[TABLE="width: 696"]
<colgroup><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Item name[/TD]
[TD]Item No.[/TD]
[TD]Date of Movement[/TD]
[TD]Sum of Quantity[/TD]
[TD]Running Total that works[/TD]
[/TR]
[TR]
[TD]Frami S Xlife universal panel 3'-0"x6'-0"[/TD]
[TD="align: right"]588808500[/TD]
[TD="align: right"]2/6/2018[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]3/5/2018[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]3/29/2018[/TD]
[TD="align: right"](7)[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Frami S Xlife universal panel 3'-0"x9'-0"[/TD]
[TD="align: right"]588807500[/TD]
[TD="align: right"]2/6/2018[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]3/5/2018[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]3/29/2018[/TD]
[TD="align: right"](7)[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Super plate 15.0[/TD]
[TD="align: right"]581966000[/TD]
[TD="align: right"]2/6/2018[/TD]
[TD="align: right"]450[/TD]
[TD="align: right"]450[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]3/5/2018[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]480[/TD]
[/TR]
</tbody>[/TABLE]


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.

[TABLE="width: 871"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Item name[/TD]
[TD]Item No.[/TD]
[TD]Type of Transaction[/TD]
[TD]Number[/TD]
[TD]Date of Movement[/TD]
[TD]Sum of Quantity[/TD]
[TD]Running Total NOT Working[/TD]
[/TR]
[TR]
[TD]Frami S Xlife universal panel 3'-0"x6'-0"[/TD]
[TD="align: right"]588808500[/TD]
[TD]Delivery[/TD]
[TD="align: right"]412249997[/TD]
[TD="align: right"]2/6/2018[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]412250407[/TD]
[TD="align: right"]3/5/2018[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Return[/TD]
[TD="align: right"]412421026[/TD]
[TD="align: right"]3/29/2018[/TD]
[TD="align: right"](7)[/TD]
[TD="align: right"](7)[/TD]
[/TR]
[TR]
[TD]Frami S Xlife universal panel 3'-0"x9'-0"[/TD]
[TD="align: right"]588807500[/TD]
[TD]Delivery[/TD]
[TD="align: right"]412249997[/TD]
[TD="align: right"]2/6/2018[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]412250407[/TD]
[TD="align: right"]3/5/2018[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Return[/TD]
[TD="align: right"]412421026[/TD]
[TD="align: right"]3/29/2018[/TD]
[TD="align: right"](7)[/TD]
[TD="align: right"](7)[/TD]
[/TR]
[TR]
[TD]Super plate 15.0[/TD]
[TD="align: right"]581966000[/TD]
[TD]Delivery[/TD]
[TD="align: right"]412249997[/TD]
[TD="align: right"]2/6/2018[/TD]
[TD="align: right"]450[/TD]
[TD="align: right"]450[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]412250407[/TD]
[TD="align: right"]3/5/2018[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]30[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 696"]
<colgroup><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]


[/TD]
[/TR]
</tbody>[/TABLE]