| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2 data sets in pivot tables
Can someone advise - when creating a pivot table showing 2 sets of data in
the summary section in Excel 2003, if you drill down to display only one set of data, the drop down arrow allowing you to select "All" disappears. How do you go back to showing both sets without dragging the field in again? Thanks -- Syrinx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum data in Pivot Tables | Excel Discussion (Misc queries) | |||
| Distributing Pivot Tables where pivot table data can't be accessed | Excel Discussion (Misc queries) | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Hybrid Mode
