Excel Forum
Similar Content
Easy Pivot Table in Excel (Auto-Subtotals Feature)
Tutorial: How to make a paired-down version of a Pivot Table for Excel. This allows you to quickly ...
Reuse Pivot Table Filters in Row, Column, & Value Fields
Tutorial: 2 ways to add Pivot Table Filter Fields (page fields) to row, column, and value fields wh...
Pivot Chart Formatting Copy Trick in Excel - Excel Quickie
Tutorial: Easily copy Pivot Chart formatting from one Pivot Chart to another Pivot Chart in Excel. ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.