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