it can definitely be done manually. It would be the code to do it that I am
looking for.
Thanks
"Dave Peterson" wrote in message
...
I don't think you can group text values like this. Maybe you could add
another
helper column to your raw data and put a formula that "groups" the data
for you.
(Maybe a =vlookup() if you have lots of categories/groups.)
Keith Young wrote:
I have read the help and there is example code for Grouping numbers/date
in
a pivotfield. However, I am interested in grouping specific text values
in
a pivotfield which may not be in any specific order. For example, say a
pivotfield has the following values:
aaa
bbb
ccc
ddd
eee
Using code, I would like to group aaa and ccc and call it GroupX; bbb
and
ddd would be grouped and called GroupY and eee would be in its own group
called GroupZ.
Can this be accomplished somehow using the group method (maybe using an
array of the text values that are to be grouped)?
Thanks, Keith
--
Dave Peterson