T
T. Jenkins
I'm trying to do a unique count in Pivot Tables. For
example, I have data by supplier, and a given supplier
might be listed 20 times for a given category. When I use
the count function in the Pivot, I get a value of 20 for
that supplier, but it's really just one unique supplier.
I've read the help, which tells me to include the supplier
in both the row and data fields, but that adds a bunch of
rows I don't need.
Any suggestions?
example, I have data by supplier, and a given supplier
might be listed 20 times for a given category. When I use
the count function in the Pivot, I get a value of 20 for
that supplier, but it's really just one unique supplier.
I've read the help, which tells me to include the supplier
in both the row and data fields, but that adds a bunch of
rows I don't need.
Any suggestions?