Pivot table and counting.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Back
Top