A Pivot table issue
Hi,
You'll need to create a new column and place formula
like you have written, but use '=left(A1,Find("-",A1)-1)'.
You can then use this new column in your pivot table. You
need to give the column a name as well, like Part Group or
something, your choice.
regards
KM
-----Original Message-----
Hi everybody!
Is it possible to create a pivot table, but to use only a
part of a field as
a row filed, not an entire field.
I have in the column 'Parts' thge following data
Parts Numbers
---------
Vehicle-Doors 1
Vehicle-Wheels 2
and I woulf like to create a pivot, but somehow to have
Left(part,6), so I
will have grouping by Vehicle only.
I can manage this adding additoonal column to the sheet,
but I think there
should be a way using some formula or so.
Thanks in advance
../Yakimo
.
|