Count Unique Values in PivotTables in Excel

Count unique values in PivotTables in Excel using the new Distinct Count function.
When working with PivotTables the Count function will count all occurrences of a value. However, you may be trying to answer how many unique products were sold in a country, or how many unique customers are in that country.
This video looks at answering such questions by using the Distinct Count function in Excel PivotTables.
Find more great free tutorials at;
www.computerga...
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/Ultimat...
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1

[@lagundafire]

9 years later and still valid! Thank you.

[@Computergaga]

You're welcome!

[@thoughts_for_sail]

I can't thank you enough!!! I have been sitting for entire day searching for just what you beautifully described. thanks again

[@Computergaga]

Great to hear. Thank you very much.

[@deepthiinamdar]

Even though it's very old tutorial, it was extremely helpful and saved lot of my time. thanks 🙂

[@Computergaga]

Glad to hear that! You're welcome.

[@Kzchi]

9 years later, still I must say thank you for the contribution! HAHAHA

[@Zandor434]

i have been looking for this for weeks now. I agree w/ others below that said this is complicated before this feature. thanks a lot for the tutorial.

[@chancebingen6760]

9 years later, it still works. Thanks!

[@Computergaga]

You're welcome! Great to hear.

[@user-bd8eq8oo1k]

Clicking the add data to model changed my afternoon lol

[@snielsen60187]

Finally!!! I've been waiting for this one. The formulas to do this in previous versions were awful. Thanks for sharing this new feature.

[@Computergaga]

No problem Sandy. I love these beautiful new features

[@Just_in_Rich]

Oh dear!! All those sumproduct gymnastics couldn't do a thing for me. Thanks a ton for making this video.

[@Computergaga]

😊 No worries, Kelvin.

[@mohamedmuse8183]

Can't thank you enough! this has been of huge help!

[@Computergaga]

Great! You're very welcome.

[@sunilsaney2459]

Was looking for this solution for a very long time. Thank you for sharing

[@Computergaga]

No problem 👍 Happy to help.

[@alvint1553]

This is great stuff! However I seem to have a problem after this, I can't seem to use the option "show items with no data". Just wondering if you know of a workaround this?

[@user-eh9uj8ey5m]

This is crisp, precise and what i needed. you saved my day!

[@Computergaga]

You're welcome 🙂

[@jrkl1622]

Lovely! Apt & cleanly explained. You really don't know how many you saved from getting a headache even after 7yr :)

[@Computergaga]

Thank you 😊

[@OdayaGuzman]

Thanks, I solved it with your video very quickly.

[@Computergaga]

Awesome! Great to hear that.

[@chrisbates8896]

Excellent. This worked when other recommendations did not. However, I do have a problem that came after. On the new pivot table created, I can calculate the unique count I need, but cannot then add a calculated field using that number. Any work around? Thank you

[@centurychallenger]

use GETPIVOTDATA, maybe

[@aloobi]

It's been almost 10 years but this video is still useful 👍🏼

[@Computergaga]

Great to hear! Thank you.

[@amezy-i3v]

You saved me 45 minutes of a headache!! ! THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@Computergaga]

You're welcome. Happy to help Ana.

[@kimfloberg4824]

The year is 2023 and I just found this ancient solutions to my problem, THANK YOU Sir!!!

[@Computergaga]

You're very welcome.

[@tomastamar2717]

many, many thanks, my reporting head ache lasting for years resolved in 3:36min 🙂

[@Computergaga]

Love it! You're very welcome.

[@krismaly6300]

I enjoyed watching this video and recommend others to watch
Thanks for educating the community and appreciate your volunteership.
Keep posting some more videos.
Thanks a bunch

[@prtkaushik319]

This video is really very helpful
Thank for sharing

[@Computergaga]

Glad it was helpful!

[@alexandrkrav]

Thanks a lot!!!! It help me to make show what I want in my PIVOT TABLE. Please let me know how I can share Coffe with you!!!

[@Computergaga]

Excellent! Happy to help.

[@saurabh482]

You r awesome. I was being thinking how to do it. But after watched your video I cracked it..

[@Computergaga]

Excellent 😊 Nice work Saurabh 💪

[@tomjohn4183]

Awesome! Thank you so much for sharing it!

[@Computergaga]

My pleasure!

[@LaClarius]

AHHH Amazing, you just saved me soo much time!! Thank you!!

[@Computergaga]

Excellent! Thank you, Lauren.

[@beyenpe]

great tutorial, I used to know this then forgot and very hard to find it again just by randomly typing lol thanks a lot!

[@Computergaga]

Glad I could help! Thank you 👍

[@brentschrodetzki9683]

you made my life so much easier. thanks

[@SubhrajitMazumder]

You saved my night!! Big Salute to you!!

[@Computergaga]

You're welcome! Thank you 😊

[@kunalDking]

I have been searching for this one for long time.. finally.. it helped me a lot.. thank you sooo much

[@ekanshagarwal2798]

Thank You Man!!

[@Computergaga]

You're very welcome!

[@samuelkodjoe1645]

you got real brains.....wow!!!!!!!

[@Computergaga]

😊

[@Murtala48]

Simple and straightforward. Many thanks

[@Computergaga]

You're welcome!

[@Berzaku]

Exactly what I was looking for thank you!

[@Computergaga]

Glad I could help!

[@its_sohn]

!!YOU DID IT!!

[@kurapatikesavasatyanarayan1045]

You saved my 8 hours of work🛐

[@Computergaga]

Excellent! That is great.

[@ahadibuge5246]

Thank you,
But the feature is not available in the excel for mac? 360

[@goldenpikerman7801]

Thanks for sharing... very helpful to me...

[@Computergaga]

Great to hear 👍

[@davisblair09]

Valuable lesson, thanks!

[@olivierjonard1872]

oh my god !! Eventually it is there. You made my day, really.

[@Computergaga]

Great to hear. Thanks Olivier.

[@peterspindley5965]

Thanks for this, is going to save me hours

[@Computergaga]

No problem 👍

[@hillarylarman8043]

Very helpful! Thanks!

[@mahalirthittam3835]

Very useful Thank you

[@Computergaga]

You're very welcome, Mahalir.

[@Sarah-nl3dn]

You have been really helpful. Thankyou so much 😊. I am so grateful

[@Computergaga]

My pleasure, Swati 👍

[@ashleighcarlos9717]

Thank you for this video. It was a huge help.

[@user-wx8wq3ls1l]

Very nice! I liked it

[@Computergaga]

Thanks a lot!

[@monaghanmd84]

Used distinct count but I want to see a trend of the distinct count each month. However, the total columns are ones (1) for each month with data. I want to know how many distinct customers bought that month. What did I do wrong? Thanks for the help.

[@Stitchdaisy1921]

THANK YOU!

[@Computergaga]

You're welcome Joy.

[@luvlycan]

You are God... Thank you so much

[@Computergaga]

No worries.

[@deepakkumarajha7745]

Wow! Thank you so much. I found great info here. 🙏

[@Computergaga]

Awesome! Great to hear.

[@michaelmohsen3048]

Excellent content

[@Computergaga]

Thank you, Michael 👍

[@kingviru1]

Really fantastic sir

[@Computergaga]

Many many thanks Kiruba.

[@luideveyra6259]

Your awesome! Thank you!

[@Computergaga]

You're welcome, Lui 😊

[@sudiptodebnath4085]

Can't Thank You Enough

[@Computergaga]

☺️

[@wideeyeddreaming]

Thank you so much!

[@Computergaga]

You're welcome! Great to hear.

[@its_sohn]

!! GREAT VIDEO !!

[@Computergaga]

Thank you 😊

[@serafeim1985]

Thank you very much!

[@JustLiving305]

Bro thank you so freaking much, division manager comes back tomorrow and I was supposed to do a report for him last week but I just couldn't for the life of me find out how to make the pivot table count unique values only once

[@Computergaga]

Your welcome my friend.

[@JarnailSingh-lr5fi]

Thanks really helpful

[@Computergaga]

No worries. Thank you, Jarnail.

[@biswajitgorai65]

Thanks a ton!!

[@Computergaga]

You're welcome, Biswajit.

[@TheVchrung]

Thank you

[@Computergaga]

You're welcome

[@katlegomoeletsi]

Thanks a mill man. Really simplified a lot of things

[@Computergaga]

Happy to help, Katlego. Thank you.

[@paulsuchanoff455]

exactly what I was looking to do thanks

[@Computergaga]

Great!!

[@arkd3um1988]

GENIUS! THANK YOU!!!!!

[@Computergaga]

Thank you.

[@sundaramkumarappan5244]

i have a problem with the grand total, it does not match when using Distinct count, can you throw some light on this please

[@vanacharlasaipavankumar6331]

Wow super helped so much 👏

[@Computergaga]

Awesome! Happy to help.

[@mandg5409]

hello, if I add a time element into columns and sales into value, how do I stop count of customer splitting by time and just stay as a total?

[@Computergaga]

Sounds like you do not need the time in the Columns area. Putting it there should give you a row of column labels grouping the time by hour.

[@birasafabrice]

thanks for this helpful video

[@Computergaga]

You are very welcome.

[@sanatanpradhan4547]

thank you

[@Computergaga]

You're very welcome.

[@TurnerTBone]

Thanks - this is great - very clear tutorial

[@ranjansingh3928]

Thank you so much

[@Computergaga]

You're welcome. Thank you, Ranjan.

[@SAM_CAST_GB]

Very useful

[@Computergaga]

Thanks a lot

[@alijuratli]

easy, nice and clear, thank you so much.

[@Computergaga]

You're very welcome Ali 👍

[@vicenteizquierdo740]

Thanks very much for your tip !

[@Computergaga]

You're very welcome. Thank you Vicente.

[@avishkaravishkar1451]

Thanks a lot!

[@Computergaga]

You're welcome, Avishkar.

[@arunjohn8540]

Thank you so much ...

[@Computergaga]

You're welcome, Arun.

[@fahatullahkhan7737]

very useful...

[@reniersteytler1859]

Very valuable

[@Computergaga]

Thank you Renier.

[@Xubilaj]

Thank you so much. very helpful
Ханж,анав

[@Computergaga]

You're very welcome.

[@robertk883]

Thank YOU bro$

[@Computergaga]

My pleasure. Thank you.

[@andrewmcdermott9517]

Thank you! Very helpful

[@Computergaga]

You're welcome Andrew. Thank you.

[@ivoheemskerk4509]

Awesome thanks for the vid

[@Computergaga]

Your welcome Ivo.

[@Asambalah]

Thank you for sharing !

[@Computergaga]

You're welcome Asambalah.

[@RetaxChennai]

Life saver!

[@Computergaga]

Happy to help, Karthik.

[@shephafun9320]

Awesome!!!

[@Computergaga]

Thank you 👍

[@senthisuryareception3930]

Man !! you rock !! awesome trick

[@Computergaga]

Thank you Senthisurya.

[@brunoazevedo9035]

SOLID! THANKS MAN~

[@Computergaga]

My pleasure Bruno 👍

[@josecarlosmatus]

Is it possible to get same result in Excel 2010?

[@Computergaga]

That function is not available to PivotTables in 2010 unfortunately. However there is always a way. This blog post will show you a method - www.computergaga.com/blog/count-unique-values-in-a-pivottable/

[@gajankumarr7542]

After setting the "Add this data to the Data Model" checkbox, excel does not allow to drill down (Double click) from the PIVOT. Any solution ?

[@TheBlackbd]

Skip to 1:30. You're welcome.

[@cristinaretamal3970]

thanks!

[@Computergaga]

You're welcome, Cristina.

[@sharierriaz7894]

Thanks alot

[@Computergaga]

You're very welcome Sharier.

[@HealthyConversation123]

It does meet the purpose. However, other coloumns and rows are completely changing it format.

[@Computergaga]

I'm not sure what you mean by the changing format.
Column formatting can be set in the data model, but this shouldn't be an issue for unique values.

[@kkapil1986]

thanks mate

[@Computergaga]

No problem Kapil.

[@spartamooseXO]

THANK YOU SO MUCH!

[@Computergaga]

You're very welcome Emma.

[@tannertucker22]

Thank you. I have Excel 2016. Why is my add to data model inactive / grayed out. Thank you.

[@haroldjameslazo]

Thank youuu

[@Computergaga]

Welcome 😊

[@yogendrapratapmishra_yogi404]

Thx you

[@Computergaga]

My pleasure. Thank you.

[@jcvanrooyen5372]

genius!

[@d_vanti4109]

I agree with Sandy

[@hazemali382]

I love this video ♥

[@Computergaga]

Awesome! Thank you Hazem.