Pinterest Pixel

Pivot Table Count Transactions

The default Value Field Setting when analyzing data with a Pivot Table is to Sum, but you... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Pivot Table Count Transactions | MyExcelOnline

The default Value Field Setting when analyzing data with a Pivot Table is to Sum, but you can also analyze a Pivot Table with a Count.

This is useful when you want to see how many sales transactions  took place within a region, a month, a year or per business unit.

Pivot Table Count Transactions | MyExcelOnline
download workbookCount.xlsx

 

Here is the current setup of our Pivot Table wherein we are getting the sum of sales:

Pivot Table Count Transactions

STEP 1: Right click on your Pivot Table and select Summarize Values By > Count

Pivot Table Count Transactions

With just that, the counts are now being shown!

Pivot Table Count Transactions

Helpful Resource:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Pivot Table Count Transactions | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!