LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,979
Default Sorry - Pivots and Me Again!!

You can drag the page field temporarily to the Row area, select the
items you want, then drag it back to the Page area.
Or, double-click on the Page field button, and in the Hide Items list,
click on items to hide. Click on hidden items to show them again.

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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivots/Charts Galway[_2_] Charts and Charting in Excel 0 May 30th 08 10:57 PM
several pivots officegirl Excel Discussion (Misc queries) 0 December 11th 07 07:04 PM
Pivots vqthomf Excel Programming 1 November 29th 05 06:12 PM
I would like to build macro's to do pivots or part of pivots Todd F.[_2_] Excel Programming 2 July 29th 05 03:59 PM
Pivots using other pivots and dynamic query problem lc Excel Programming 0 November 7th 03 03:02 PM


All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"