Predictive Hacks

Count Distinct Values in Excel Pivot Tables

In Excel Pivot tables there is no direct “count distinct” option. Let’s see how we can get it. Assume that our data is the following:

and we want to get the count distinct values by group. How we have to do is:

  • Step 1: Select your data
  • Step 2: Insert–>PivotTable
  • Step 3: Tick the “Add this data to the DataModel”
count distinct excel pivot table

Now, you are able to select the “CountDistinct”

And we get the count of the distinct values as we can see below!:

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email

Subscribe To Our Newsletter

Get updates and learn from the best

More To Explore

Python

Image Captioning with HuggingFace

Image captioning with AI is a fascinating application of artificial intelligence (AI) that involves generating textual descriptions for images automatically.

Python

Intro to Chatbots with HuggingFace

In this tutorial, we will show you how to use the Transformers library from HuggingFace to build chatbot pipelines. Let’s