Sorry - Pivots and Me Again!!

[Sharon]

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

[Excelenator]

I'm not sure about programatically doing this but there is a manual way to do this. If you drag your page field down to the rows section as the first field you can click the select arrow, check or uncheck the items you want or don't want and then drag the field back up to the page section. The pivot will now be based on your multiple selections.

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