Sudhir Prabhu
Member
Folks,
Here's a poser on Excel Pivots !
'Count Distinct' as a Value field setting is only available in Pivot, if the Pivot is created as a Data Model. However, In Data Model type of Pivot, a useful feature of 'Calculated fields' is suppressed ! Is there a way to achieve either (a) count distinct in regular pivot table or (b) calculated field in data model pivot ?
For now, i create two pivot charts - one on data model and other regular, and then copy paste the result on the other - crude, but works for now. Thoughts ?!
PS: I found a similar post here - though it's silent on this specifically (I hope it is not 'Not possible') https://chandoo.org/wp/distinct-count-pivot-tables/
Thanks !
Regards,
Sudhir
Here's a poser on Excel Pivots !
'Count Distinct' as a Value field setting is only available in Pivot, if the Pivot is created as a Data Model. However, In Data Model type of Pivot, a useful feature of 'Calculated fields' is suppressed ! Is there a way to achieve either (a) count distinct in regular pivot table or (b) calculated field in data model pivot ?
For now, i create two pivot charts - one on data model and other regular, and then copy paste the result on the other - crude, but works for now. Thoughts ?!
PS: I found a similar post here - though it's silent on this specifically (I hope it is not 'Not possible') https://chandoo.org/wp/distinct-count-pivot-tables/
Thanks !
Regards,
Sudhir
Last edited: