Take a look at how Debra Dalgleish approaches it:
http://contextures.com/xlPivot07.html#Unique

cv8497 wrote:

I have a list of data in which I wat to pivot to show only the number of
different occurances in column "A"(this example is two-bub & ubu) but i also
want it to pull in all occurances of column A when i click on that finding in
the pivot table. is that possible?

A B
1 bub 1.25
2 bub 2.25
3 ubu 3.15
4 bub .98
5 ubu 1.25
6 bub .12

--

Dave Peterson