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
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.