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.