Remove grouped items and fields from pivot table

T

Tom Harwell

When items are grouped a new field with new items are created. Is it
possible to remove them completely without redefining the data source for a
new pivot table?
 
T

Tom Harwell

I found that once you ungrouped everything under the new field, the new field
disapeared.
 

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

Pivot ungrouping on refresh? 3
Rank in Pivot Table 3
Pivot table not recognizing same field values 1
Pivot Table and Grouping Problem 3
Group in Multiple Pivot table 1
how to show repeating data in pivot table (not grouped) 2
Pivot ... Drag Multiple Fields from Field List? 1
Pivot table data layout - columns to rows 1

Top