ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   2 data sets in pivot tables (https://www.excelbanter.com/excel-worksheet-functions/194376-2-data-sets-pivot-tables.html)

SYRINX

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


All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com