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

Count

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

Share on Google+

Google+

Related Posts

Excel’s Fill Handle Tips This post was inspired by Mr.Excel's new book MrExcel XL: 40 Greatest Excel Tips of All Time and in particular the 3rd tip that I read called The Fill Handle Does Know 1,2,3... Excel knows to fill down/right when you are working with dates, days, months, years and even quarter...
Microsoft Excel Pivot Tables Online Tutorial Pivot Tables are one of the most powerful features of Microsoft Excel. They allow you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, highlight key information to management and include graphs for your monthly p...
Row Differences If you have two rows that you want to compare, for example, sale amount versus amount paid, you can easily filter the differences between these two columns by going in to the Find & Select > Go To Special > Row Differences. Once the cells have been identified, you ca...
Show The Percent of Parent Column Total With Excel...   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT COLUMN TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers suc...