SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-266195%22%20slang%3D%22en-US%22%3Ehow%20to%20%22count%20distinct%22%20a%20field%20in%20a%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266195%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20following%20article*%20states%26nbsp%3Bthat%20the%26nbsp%3B%3CSPAN%3Esummary%20function%20count%20distinct%20only%20works%20when%20you%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-a-data-model-in-excel-87e7a54c-87dc-488e-9410-5c75dbcb0f7b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Euse%20the%20Data%20Model%20in%20Excel%3C%2FA%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20think%20I've%20followed%20all%20the%20steps%2C%20described%20in%20the%20link%2Farticle%20but%20I%20still%20can't%20apply%20the%20count%20distinct%20function.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAny%20tips%20%2F%20advice%20would%20be%20much%20appreciated!%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E*%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fsum-values-in-a-pivottable-9ee73790-646a-42c9-9fc7-e1ca30096d9c%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fsum-values-in-a-pivottable-9ee73790-646a-42c9-9fc7-e1ca30096d9c%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-266195%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266302%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20%22count%20distinct%22%20a%20field%20in%20a%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266302%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20a%20lot%2C%20Detlef%20Lewin%20!%20That's%20what%20I%20missed.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266209%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20%22count%20distinct%22%20a%20field%20in%20a%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266209%22%20slang%3D%22en-US%22%3E%3CP%3EDid%20you%20really%20clicked%20the%20check%20box%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20401px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F55361i3D4E838D5E0CC857%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22new-pivot-table%22%20title%3D%22new-pivot-table%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi everyone,

 

the following article* states that the summary function count distinct only works when you use the Data Model in Excel.

 

I think I've followed all the steps, described in the link/article but I still can't apply the count distinct function.

 

Any tips / advice would be much appreciated! 

 

 

*:

https://support.office.com/en-us/article/sum-values-in-a-pivottable-9ee73790-646a-42c9-9fc7-e1ca3009...

 

 

2 Replies
Highlighted
Best Response confirmed by Herman Vanmulken (New Contributor)
Solution

Did you really clicked the check box?

new-pivot-table

Highlighted

Thanks a lot, Detlef Lewin ! That's what I missed.