How does POWER PIVOT do de-duplication, sort and count

[choletseng]

I heard that POWER PIVOT can also do it, no need to write a formula, may I have a detailed production process for this question,

Who can teach me with pictures ?

Any help would be appreciated!

Thank you

[wk9128]

1. Main menu\ insert \ pivot table Then follow P1.JPG file
2. follow P2.JPG file

[choletseng]

Problem solved, this is too helpful for me

wk9128 Thanks you very much

[wk9128]

@choletseng You're Welcome. Glad to help . Thank You for the feedback