Enable Distinct Count for Pivot Tables

Thank you so much! Great help.

But I am unable to insert calculation field on data model pivot

Thanks bro!

in 365 excel version data model option in not showing

In mine.. it is also considering the heading rows and reflwcting it in the pivot table as (blank) and counted it as 1. How to rectify it?

Ok but the grand total sum was wrong

for the Mac how can I do this ?

Thank you so much

You are a genius

But, the count when you tick this option is mot the total number of rows in the dataset that it should be. Why is that?

Amazing, thanks bud 🙏🏾

How to do it in Mac?

Your a genius been trying to figure out how to do this for the longest

Thank you, this saved me 🙏