Forum Discussion
distinct values in pivot table on excel for Mac
Hello,
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?
ThanksWorkaround is the helper column in source data, see for example Excel PivotTables Unique Count 3 Ways • My Online Training Hub
