J
JulieD
Hi All
is there a way in a pivot table to only use (& therefore group on ) part of
a value name ... e.g.
if i have
Car Number
BMW - Blue 100
BMW - Red 20
VOLVO - Blue 50
VOLVO - Red 10
and i want a pivot table to look like this
Blue Red Total
BMW 100 20 120
VOLVO 50 10 60
150 30 180
is is possible to do this in the pivot table itself rather than in the
underlying data (which i know how to do) - using Excel 2000
Cheers
JulieD
is there a way in a pivot table to only use (& therefore group on ) part of
a value name ... e.g.
if i have
Car Number
BMW - Blue 100
BMW - Red 20
VOLVO - Blue 50
VOLVO - Red 10
and i want a pivot table to look like this
Blue Red Total
BMW 100 20 120
VOLVO 50 10 60
150 30 180
is is possible to do this in the pivot table itself rather than in the
underlying data (which i know how to do) - using Excel 2000
Cheers
JulieD