Similar Content
Understanding Formulas and Functions in Excel
Tutorial: In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A for...
Multiply by True and False in Excel
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...
Excel Formatting for Zip Codes and Phone Numbers
Tutorial: Display numbers in Excel as zip/postal codes and phone numbers in order to make them easi...

# Excel Magic Trick 498: 6 PivotTable Calculation Tricks (Pivot Table)

Use PivotTable to Group Numbers, calculate Frequency, % Total, Cumulative Total, % Cumulative Total. See how to:
1. PivotTable (Pivot Table)
2. Group Integers in PivotTable
3. Count numbers
4. use "% of Column Total" in "Value Field Settings" "Show values as" tab
5. use "Running Total in" in "Value Field Settings" "Show values as" tab
6. use "% Running Total in" in "Value Field Settings" "Show values as" tab, which is new to Excel 2010
New Excel 2010 PivotTable Pivot Table Feature "% Running Total in.

Also see this video:
Excel Statistics 26: Cumulative Freq. Dist w Pivot Table (Running Total)

Got a Question? Ask it Here in the Forum.