distinct values in pivot table on excel for Mac

Copper Contributor


there is no function on Mac Excel to get unique/distinct values when using a Pivot table to get data reports. Please help! Thanks 

4 Replies

@Julietgraz You simply can not! That's a feature exclusive to Power Pivot and is supported only by Excel on Windows.


Edit: To be more precise, I'm referring to the 'Distinct Count' setting as shown in the picture below.



Hello there Riny, thank you. So what is the solution/way around this?


Workaround is the helper column in source data, see for example Excel PivotTables Unique Count 3 Ways • My Online Training Hub