I want to "count" unique numbers using a pivot table. I enter project numbers
into a column in our job list spreadsheet. Some projects have multiple
components and each component has the same project number as the overall
project but is listed in its own row. So, within the project number column,
one project number may be listed up to 30 times. I'd like to just count the
total number of unique project numbers. I'm getting the total number of line
items in my pivot.

If it helps, the other components in my pivot table are component category
and quarter (of the year).

Thanks for any advice / tips!