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/excelpivottablecalculatedfieldcount.html
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/contextures?sub_confirmation=1
#ContexturesExcelTips #ExcelQuickTips
