Title:
Excel Magic Trick #172: Running Total Formula or Pivot Table
Video:
Description:See how to create a Running Total with a Formula or a Pivot Table. For formulas, the trick is to use the SUM function and lock one of the cells, but not the other. For example: =SUM(C$13:C13). For Pivot Tables, the trick is to add the field to the Values (or Data) area, and then right click, point to "Value Field Settings", then click on the "Show values as" tab, then select "Running total" from the "Show values as" drop down arrow, then select the "Base field" (the field in the Row area).
Published:
31/Dec/2008
Excel Magic Trick #172: Running Total Formula or Pivot Table
Video:
Description:See how to create a Running Total with a Formula or a Pivot Table. For formulas, the trick is to use the SUM function and lock one of the cells, but not the other. For example: =SUM(C$13:C13). For Pivot Tables, the trick is to add the field to the Values (or Data) area, and then right click, point to "Value Field Settings", then click on the "Show values as" tab, then select "Running total" from the "Show values as" drop down arrow, then select the "Base field" (the field in the Row area).
Published:
31/Dec/2008
No comments:
Post a Comment