ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Returning to multiple data fields pivot table view (https://www.excelbanter.com/excel-worksheet-functions/226361-returning-multiple-data-fields-pivot-table-view.html)

ohadn77

Returning to multiple data fields pivot table view
 
Hi,

My pivot table contains a "Data" column consisting of several DATA fields.
When I want to view only one of the fields, I use the down-arrow of the Data
column header, deselect the undesired fields and keep the desired one
selected.
When I confirm, Excel disposes the Data column and shows the selected field
at a different location on the pivot table.
Now, when I want to view all fields again, I have to redefine them and their
settings all over again.
Is there a way to keep the Data column in place, even when only one field is
currently selected?

Thanks.


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

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