Home

Pivot Table – Running Total

%3CLINGO-SUB%20id%3D%22lingo-sub-821477%22%20slang%3D%22en-US%22%3EPivot%20Table%20%E2%80%93%20Running%20Total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-821477%22%20slang%3D%22en-US%22%3EHi%2C%20we%20need%20help%20regarding%20running%20total%20in%20pivot%20table.%20We%20need%20a%20running%20total%20of%20the%20column%20%E2%80%98CURRENT%20PRODUCT%E2%80%99%20and%20divide%20the%20%E2%80%98RUNNING%20CURRENT%20PRODUCT%E2%80%99%20by%20the%20%E2%80%98RUNINNG%20TOTAL%20ON%20TONS%E2%80%99%20to%20get%20the%20grade%20(in%20pink%20in%20the%20screen%20shot.%20We%20are%20on%20this%20case%20since%205%20days.%20PDF%20files%20attached%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-821477%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-822118%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20%E2%80%93%20Running%20Total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-822118%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F397825%22%20target%3D%22_blank%22%3E%40MBK-TechnicalServices%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERunning%20totals%20in%20pivot%20tables%20are%20easily%20created%20by%20selecting%20%22Show%20values%20as%22%20%26gt%3B%20%22Running%20totals%22%2C%20as%20described%20in%20this%20tutorial%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcontexturesblog.com%2Farchives%2F2010%2F03%2F03%2Frunning-totals-are-easy-with-excel-pivot-tables%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcontexturesblog.com%2Farchives%2F2010%2F03%2F03%2Frunning-totals-are-easy-with-excel-pivot-tables%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20summary%3A%20right-click%20a%20value%20in%20the%20column%20and%20select%20%22Value%20field%20settings%22.%26nbsp%3B%20Click%20the%20tab%20%22Show%20Values%20As%22%20and%20select%20%22Running%20Total%20in%22%2C%20then%20select%20the%20time%20value%20field%20that%20you%20are%20grouping%20the%20data%20by.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20works%20for%20regular%20pivot%20tables%20as%20well%20as%20pivot%20tables%20from%20the%20Power%20Pivot%20Data%20Model%20with%20DAX%20measures.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
MBK-TechnicalServices
Occasional Visitor
Hi, we need help regarding running total in pivot table. We need a running total of the column ‘CURRENT PRODUCT’ and divide the ‘RUNNING CURRENT PRODUCT’ by the ‘RUNINNG TOTAL ON TONS’ to get the grade (in pink in the screen shot. We are on this case since 5 days. PDF files attached
1 Reply

Hello @MBK-TechnicalServices ,

 

Running totals in pivot tables are easily created by selecting "Show values as" > "Running totals", as described in this tutorial https://contexturesblog.com/archives/2010/03/03/running-totals-are-easy-with-excel-pivot-tables/

 

In summary: right-click a value in the column and select "Value field settings".  Click the tab "Show Values As" and select "Running Total in", then select the time value field that you are grouping the data by.

 

This works for regular pivot tables as well as pivot tables from the Power Pivot Data Model with DAX measures.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies