Using Pivot to get a count of distinct values

Nick Sor
Nick Sor ✭✭✭✭

Hello,

Is it possible to use Pivot to get a count of distinct values? I want to count the number of unique values in a column, but am only able to see options for SUM, AVERAGE, and, COUNT.

Thank you

Answers