Hi hi,


Do you know how to count unique items in PivotTable? Currently when I do a count it adds up all the items not the unique items.

For Example

ItemA
ItemA
ItemA
ItemB

Should result in 2 unique items but instead I get 4 items.

I am sure there is something I can do in calculated field but I just can't think of it. Any ideas?

Thanks,
~RUTH~