what's not easy about Debra's method. I use it all the time.

--
Regards,
Tom Ogilvy


"Sharon" wrote:

Thanks a lot Debra and Jim - thought as much - no easy way to do it!!

Thanks again for taking the time to reply.

REgards
--
Sharon


"Jim Thomlinson" wrote:

Nope. You can not multi select unless the pivot is based on an OLAP cube. The
work around is to build a dynamic heirarchy structure into your source data.
It is a real pain to do though and requires refreshing the pivot each time
the hierarchy is changed...
--
HTH...

Jim Thomlinson


"Sharon" wrote:

Hi Sorry about coming back again, but I have a question about page fields.
Is it possible to make a multiple selection from a page field? And if so,
can it be done programatically? I know it can be done if the pivot is based
on an OLAP cube but it would be great if it could be done with a pivot based
on a data range.

Any help would be really welcome.

Thanks
--
Sharon