| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Select multipul 'Page' items in a Pivot Table
Hi,
I have a Pivot Table with 9 'Page' items. But I can only choose either 'All' or just one from each of the lists. Is there a way to get the 'check boxes' in the 'Page' part - ie the same as in the 'Row' data please? I've put the Page items into the Row but this makes my sheet too wide to fit all the columns on the page. Any ideas are greatly appreciated. Thanks in advance, AW |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Select multipul 'Page' items in a Pivot Table
You can't get check boxes in the page field in Excel 2000. To hide items
you can do the following: In the pivot table, double-click the page field button. In the PivotTable Field dialog box, there's a 'Hide items' list Click on an item in that list to hide it. To see that item again, click on the item in the list, to unselect it. Click OK to close the dialog box. ArcticWolf wrote: I have a Pivot Table with 9 'Page' items. But I can only choose either 'All' or just one from each of the lists. Is there a way to get the 'check boxes' in the 'Page' part - ie the same as in the 'Row' data please? I've put the Page items into the Row but this makes my sheet too wide to fit all the columns on the page. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Select multipul 'Page' items in a Pivot Table
The practical answer is Put The page file part in starting of columns.
"ArcticWolf" wrote: Hi, I have a Pivot Table with 9 'Page' items. But I can only choose either 'All' or just one from each of the lists. Is there a way to get the 'check boxes' in the 'Page' part - ie the same as in the 'Row' data please? I've put the Page items into the Row but this makes my sheet too wide to fit all the columns on the page. Any ideas are greatly appreciated. Thanks in advance, AW |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Select multipul 'Page' items in a Pivot Table
sorry in row area actually. "ArcticWolf" wrote: Hi, I have a Pivot Table with 9 'Page' items. But I can only choose either 'All' or just one from each of the lists. Is there a way to get the 'check boxes' in the 'Page' part - ie the same as in the 'Row' data please? I've put the Page items into the Row but this makes my sheet too wide to fit all the columns on the page. Any ideas are greatly appreciated. Thanks in advance, AW |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| top items in a pivot by page | Excel Discussion (Misc queries) | |||
| Excel 2003 and 2007 and Select Multiple Items on Pivot AS Cube bug | Excel Discussion (Misc queries) | |||
| Pivot Table dropping items from page item list | Excel Discussion (Misc queries) | |||
| Setting page frame for a table of several hundred items | Excel Discussion (Misc queries) | |||
| Pivot Tables, can I use an external list to select data items? | Excel Worksheet Functions | |||
Linear Mode
