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