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 WORKBOOK

 

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

Pivot Table Count Transactions | MyExcelOnline

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

Pivot Table Count Transactions | MyExcelOnline

With just that, the counts are now being shown!

Pivot Table Count Transactions | MyExcelOnline

Helpful Resource:

728x90

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Pivot Table Count Transactions | MyExcelOnline