Prev: Help with lookup and formulas
Next: optimum method to print rows as columns
From: reza on 10 Feb 2010 03:04
Hi all...

simple question about pivot table
i have 2 column
names fruit
reza apple
reza orange
reza apple

what i want to do, create pivot table with results
reza
apple 1
orange 1

but when i created that, the result is:
reza
apple 2
orange 1

thanks....
From: Eduardo on 10 Feb 2010 08:06
Hi,
The information you get in the pivot table is correct in your original list
you have apple twice, before and after orange

"reza" wrote:

> Hi all...
>
> simple question about pivot table
> i have 2 column
> names fruit
> reza apple
> reza orange
> reza apple
>
> what i want to do, create pivot table with results
> reza
> apple 1
> orange 1
>
> but when i created that, the result is:
> reza
> apple 2
> orange 1
>
> thanks....
 | 
Pages: 1
Prev: Help with lookup and formulas
Next: optimum method to print rows as columns