Distinct Count With A Pivottable In Excel By Chris Menard

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 ---------------------------------
○ My camera – amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod – amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera – amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – chrismenardtraining.com/camtasia
○ Screenshots – Snagit – chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – tubebuddy.com/chrismenard

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!

Author

Ariyani

Como educador, estou profundamente engajado no desenvolvimento dos estudantes em ambiente escolar, adotando métodos pedagógicos que valorizam conexões genuínas e são movidos por inovação e fervor. É minha vocação guiar os alunos na jornada de se tornarem uma geração notável, empregando estratégias de ensino amplamente aclamadas por prestigiadas instituições acadêmicas ao redor do globo - preview.pbjmanagement.co.uk