Pivot table and counting.

[sacredarms]

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

[Roger Govier]

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 <sacredarms@discussions.microsoft.com> 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]

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