how to "count distinct" a field in a pivot table

Question

Hi everyone,&nbsp;the following article* states&nbsp;that the&nbsp;summary function count distinct only works when you&nbsp;use the Data Model in Excel.&nbsp;I think I've followed all the steps, described in the link/article but I still can't apply the count distinct function.&nbsp;Any tips / advice would be much appreciated!&nbsp;&nbsp;&nbsp;*:https://support.office.com/en-us/article/sum-values-in-a-pivottable-9ee73790-646a-42c9-9fc7-e1ca30096d9c?ui=en-US&amp;rs=en-US&amp;ad=US&nbsp;&nbsp;

detlef_lewin · Accepted Answer

Did you really clicked the check box?

Forum Discussion

how to "count distinct" a field in a pivot table

Share

Resources