There are several ways to display a count in a Pivot Table but choose the wrong one and you could end up with inaccurate information!

In this video I explain the different methods you can use to create a count and show you why I prefer to use the COUNTROWS function for Data-Model based Pivot Tables.

As a bonus, I’ll show you how to ensure that you can get an accurate count where the data isn’t stored in the Data Model.

Links to the video and individual sections below:


Create Pivot Tables with a Count

The Effect of Blanks on a Count

Create a Measure Using the COUNTROWS Function

Add the Measure to the Pivot Table

Accurate Counting When the Data is in the Worksheet