Home

Table running totals for multiple items

%3CLINGO-SUB%20id%3D%22lingo-sub-724999%22%20slang%3D%22en-US%22%3ETable%20running%20totals%20for%20multiple%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724999%22%20slang%3D%22en-US%22%3E%3CP%3Ewe%20have%20inventory%20movement%26nbsp%3Bdata%20table%20for%26nbsp%3Bvarious%20stock%20items%20with%20stock%26nbsp%3BIn%20and%20Out%20information.%20Data%20is%20extracted%20from%20SQL%20database%2C%20so%20data%20keeps%20updating%20with%20new%20information%20on%20every%20refresh%20function.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20pivot%20report%2C%20where%20we%20need%26nbsp%3Bnew%20fields%20to%20table%2Freport%20such%20as%20opening%20balance%2C%20running%20balance%20and%20closing%20balance%20for%20any%20item%20at%20any%26nbsp%3Bgiven%20point%20in%20a%20time.%3C%2FP%3E%3CP%3Ecan%20someone%20help%2C%20how%20to%20write%20a%20formula%20for%20opening%20balance%2C%20running%20balance%20and%20closing%20balance%20in%20table%20or%20pivot%20report..%3C%2FP%3E%3CP%3Esee%20attached%20spreadsheet%20for%20example%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-724999%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Sam_3026
New Contributor

we have inventory movement data table for various stock items with stock In and Out information. Data is extracted from SQL database, so data keeps updating with new information on every refresh function.

 

I am trying to create a pivot report, where we need new fields to table/report such as opening balance, running balance and closing balance for any item at any given point in a time.

can someone help, how to write a formula for opening balance, running balance and closing balance in table or pivot report..

see attached spreadsheet for example

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies