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
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
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies