distinct values in pivot table on excel for Mac

Copper Contributor

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.

Riny_van_Eekelen_0-1701081491503.png

 

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

@Julietgraz 

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