If you are trying to identity how many items you have on a certain category using a pivot table like the example in green above, you will need to do a work around on a Mac, since there is no simple way to do that on a Mav (vs Windows where you can use a simple pivo table function). The work-around is create an extra column on your original data file.
This video explain how to do it. Basically, you will create an extra colum on your pivotable with the following formula: "=1/COUNTIF(SalesStateRange,BCellValue)
This will result in a column with a fractional value that represents a share of the number of times a certain value shows on the complete range, when you add those as a Sum on your pivot table you get a total number of unique values.
If you are in doubt, just watch the video.
