Create Excel Pivot Table Calculated Field With a Count

You can create calculated fields in a pivot table, to add your own formulas.

However, a calculated field always uses the SUM of another field, even if that field is displayed as a COUNT.

To get correct results, you can add a new field to your source data, to act as a counter. Then, use the new field in the calculated field, and its SUM will be used, for the results that you expected.

Watch this video to see how to create a pivot table, add a new counter field to the source data, and create a calculated field using the counter field.

Visit this page to download the sample file.
http://www.contextures.com/excelpivot...

Video Timeline
00:00 Introduction
00:38 Build Pivot Table
01:59 Create Calculated Field
02:50 Change Number Format
03:11 Calculated Field Problem
04:03 Add New Field to Source Data
05:28 Create New Calculated Field

Instructor: Debra Dalgleish, Contextures Inc.
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips #ExcelQuickTips

• #science_technology
• #excel
• #mstips
• #excel_pivot_table
• #pivot_table_calculated_field
• #excel_pivot_table_formulas
• #excel_calculated_field
• #calculated_field
• #pivot_table
• #pivot_table_formula
• #contextures
• #microsoft_excel_software