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: 23

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
You must log in or register to reply here.

Similar threads

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

Forum statistics

Threads
1,224,819
Messages
6,181,153
Members
453,021
Latest member
Justyna P

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