I have a pivot table that gives me the number of rides done by a van. I can
have the pivot table return the number of rides, but what I need is the
number vans that participated for a certain day. Example, it is possible to
have 27 trips done by 18 vans, how can I count the number of vans and not
addup the van number?

Any help appreciated.

Thank you,

Joe

Hi Joe

We need a bit more information on how your source data table is set up.
What information do you have in each column?


--
Regards

Roger Govier



sacredarms wrote:
I have a pivot table that gives me the number of rides done by a van.
I can have the pivot table return the number of rides, but what I
need is the number vans that participated for a certain day. Example,
it is possible to have 27 trips done by 18 vans, how can I count the
number of vans and not addup the van number?

Any help appreciated.

Thank you,

Joe

Debra Dalgleish shows a way to count unique items at:
http://contextures.com/xlPivot07.html#Unique



sacredarms wrote:

I have a pivot table that gives me the number of rides done by a van. I can
have the pivot table return the number of rides, but what I need is the
number vans that participated for a certain day. Example, it is possible to
have 27 trips done by 18 vans, how can I count the number of vans and not
addup the van number?

Any help appreciated.

Thank you,

Joe

--

Dave Peterson