Count Unique Values in PivotTables in Excel

↔️ ↕️


hello and welcome to this video tutorial

from and in this video

we are going to look at how to count the


occurrences of a value in our pivot


so what we'd like to achieve is we want

to be able to do

things like count how many different

products we have sold by a country

or see how many different customers we

have by

country and these kind of actions so you

want the unique

occurrences of each value

so i've got an example pivot table on my

other sheet at the moment

which is not working to plan when you

just do a

a normal count on a value and i've got a


Related queries:

pivot table count without duplicates
pivot table counting duplicate values
how to not count duplicates in pivot table
pivot table duplicate values