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.



Helpful Resource:


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


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Pivot Charts Pivot Charts in Excel are an extension of a Pivot Table and they show its values in a graphical representation.  So when you filter a Pivot Table, the Pivot Chart updates accordingly.To insert a Pivot Chart you need to click in your Pivot Table, go to the PivotTable Tools tab...
Running Total In % with an Excel Pivot Table A Running Total In is the accumulation of values over a certain period, like days, month or years.  It is sometimes referred to as the Year to Date analysis.A Running Total In takes one period's values, then adds a second period, then a third period...and so on, to give the a...
Lock & Protect Formula Cells If you have a workbook with lots of formulas and you want to protect those formulas from being amended by other people who share your workbook, then you can!You need to follow these steps:1. Press the Go To Special shortcut CTRL+G2. Select the Constants box and press ...
Text to Columns – Emails If you have a data set with text consisting of names and email addresses that are wrapped inside a parenthesis, like:John ( ...then you can use the Text to Columns feature in Excel to take out the email addresses and put them in a separate ...