Calculate a remaining balance through pivot chart

R

RaddicusBinx

New Member
Joined
Apr 1, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Desperation brought me here, as I'm banging my head against a wall trying to figure out why I can't insert a calculated field or item that would allow me to show a running remaining balance for vendors using a pivot chart. I've attached an image to show the basic set-up I've got.

Ideally the running remaining balance would show up under the grand total of accumulated costs/invoices. What step am I missing here, besides being completely stupid?
 

Attachments

  • sup.png
    sup.png
    7.9 KB · Views: 10

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
You must log in or register to reply here.

Similar threads

N
  • Question
2-step Dynamic Ranges and Charts
Replies
0
Views
172
Nick Loughton
N
T
  • Question
HELP- Pivot Table to Auto Calculate On Time Percentage Per Employee
Replies
3
Views
756
tbakbradley
T
B
  • Solved
Workaround for greyed out calculated field in pivot table from data model
Replies
1
Views
7K
RoryA
RoryA
L
  • Question
VLOOKUP in pivot table calculated field
Replies
2
Views
2K
lironprofit
L
B
  • Question
Excel Pivot Chart add Horizontal and Vertical Lines
Replies
0
Views
3K
bert132
B

Forum statistics

Threads
1,214,819
Messages
6,121,746
Members
449,050
Latest member
excelknuckles

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