Excel Distinct Count with a PivotTable

PivotTables in Excel can create a Distinct Count. An example of a distinct count is we had five orders in one day, but three orders were placed by the same customer. I want to know we have five orders from three customers. To create a distinct count in a PivotTable, there is a box you must check to have this feature enabled in your PivotTable. In this short video, I'll demonstrate a PivotTable without a distinct count, create another PivotTable with a distinct count, and finally show the awesome UNIQUE function. The tip is to select Add this data to the data model when creating your PivotTable.

Chapters/Bookmarks
0:00 Intro
0:15 PivotTable without distinct count
2:10 PivotTable with distinct count
4:15 UNIQUE Function in Excel

#msexcel #microsoftexcel #chrismenard #chrismenardtraining

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[kenpachi-gaming]

thanks man
can't get any easier than this

[ScottMoran]

Awesome, Chris! Thanks - I always search out your videos when I have a reallive business data problem to solve. I appreciate the short, on point video

[jonathanludd]

Crisp, clear and concise. But not too concise - It was like having a buddy explain something to me. Thanks

[arunkumars]

Thank you, Chris. I was looking for this, your vide saved my time, instead of using complex formulas

[celesteberban]

Great Video. Concise and clear you have mastered conveying complex functionality of Excel using simplified real world problems in record time. Great Job! So glad I found you last year. :-)

[staniayasin]

Wow, , , you really made my day Chris! So much hours saved here! Thanks a lot!!!

[GeorgeJacobT]

This was fantastic!!!! Thank YOU!! @Chris Menard

[firmaevents]

Mucu appreciated. I was searching for the answer and i saw the video. I love u man. Thanks❤

[samanthadiego]

Thank you! Was looking for this for a week now

[MrWifiBattler]

this is an awesome video! Very helpful

[roywilson]

I love the data model and power pivot, there is just so much you can do with them especially if you learn a little DAX.

[patriciarodrigues]

great Video.. right straight to the point! Thank you

[ThemisterFunland]

Thank Chris for your share this great tip.

[sezinozer]

Hi there! I'm using corporare account on excel. I don't see "add data to the data model" option. I don't see "power pivot" as well :/

[LokeshRaviMailbox]

This what am looking for.. Thanks for sharing.

[Campfire]

Very helpful Chris! Although i dont understand why Microsoft wont just make this a default. An extra step for no reason.

[cristcampos]

I need for MacOS :( Thank you for your video!

[JennaKientzy]

Hey There! Thanks for the quick video. Quick question though... Prior to right clicking and selecting distinct count on the pivot table I do not have a blank row but after I select distinct count it adds a Blank and has a count of 1. There is nothing in my data that is blank and I can't figure out how to clear it out since it is affecting my overall total.

[gerbherb]

Thanks. Problem here: I have a column with some empty cells (unknown) in it. Distinct count sees blanks as one distinct value, so it adds 1 to my result of distinct values. So, is there a way to count distinct values and skip empty cells???

[Morlich]

When i use the distinct count, another row is now unable to "sum" even though it is a row of numbers. Can you help with this?