Added columns to pivot table stop running totals

M

miwnr

New Member
Joined
Jun 18, 2016
Messages
7
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]
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
You must log in or register to reply here.

Similar threads

ExcelNewbie2020
  • Solved
sum function that will reset the running total every after 5 counts
Replies
3
Views
289
Cubist
Cubist
N
  • Question Question
Pivot Table Total
Replies
5
Views
398
neasds
N
S
  • Question Question
Scan function in calculated field in excel pivot table
Replies
3
Views
276
RoryA
RoryA
E
  • Question Question
Running total calculation
Replies
7
Views
546
KRice
K
D
  • Solved
Count total award value per unique supplier
Replies
4
Views
89
Fluff
Fluff

Forum statistics

Threads
1,223,898
Messages
6,175,272
Members
452,628
Latest member
dd2

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top