Home

Pivot table

Georgia_Osei
Occasional Visitor

I have a row with more than 100 labels and I need to group them. However, each box contains a different description. Is there a way of Applying a filter so that I can create groups. However every time I create a filter, all the other boxes disappear but i want them to remain so I can continue filtering and making more groups. A bit complicated but really need help

Related Conversations
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Problems using Pivot tables in Excel 16.25 on Mac
jeromepineau in Excel on
0 Replies