2 data sets in pivot tables

S

SYRINX

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DATE Calculations in pivot table 0
Link Drop Down with Pivot Table 2
Multiple Tables and Multiple Pivot Tables Help 0
Pivot Item Displaying Incorrect Value? 1
Retrieve Data to Pivot Table "On Demand" 1
Pivot Table Drop Down Box Disappears in Chart 0
How to clear data in pivot table? 4
Retain pivot table formatting after refreshing data 0

Top