Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A Pivot table issue
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Issue with pivot table | Excel Discussion (Misc queries) | |||
One pivot table cannot overlap another pivot issue. | Excel Discussion (Misc queries) | |||
Pivot Table Issue | Excel Worksheet Functions | |||
Pivot table sum issue | Excel Discussion (Misc queries) | |||
Pivot Table issue | Excel Programming |