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.


DOWNLOAD WORKBOOK

 

Helpful Resource:

728x90

4

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