DISTINCT count in a pivot table

[loggiaaj]

I need to count a "distinct" number of PI's in a pivot table. The pivot count function is counting ALL records within the bins I created:

$0-$200 - count the # PI's in this bin etc. etc.
$201-$400
$401-$700
over $700

I had to use a SUMIF and COUNTIF off 2 diff. columns outside the pivot - very tedious and cumbersome especially when the data array changes/grows.

any help - much appreciated - tks !

- Tony

 

[Domski]

Pivot tables don't have a built in feature to do a distinct count but this may help: http://www.contextures.com/xlpivot07.html#Unique

Dom

 

[loggiaaj]

thank you !!