ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I hide ungrouped data in a pivot table? (https://www.excelbanter.com/excel-discussion-misc-queries/151822-how-do-i-hide-ungrouped-data-pivot-table.html)

Valerie

How do I hide ungrouped data in a pivot table?
 
Hi. I have data that I have grouped in a pivot table (this created another
field). I want to keep the new field but when I go to hide the ungrouped
data, I loose the grouped data (it shows me the data ungrouped). Does anyone
know of a way to hide the column with the ungrouped data so that I am left
with grouped data? Thank you.


All times are GMT +1. The time now is 02:18 AM.

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