Forum Discussion
Solved
Field grouping/grouping not working in pivot table
Hi, I spend some hours trying to bundle data in groupings in my table. Still no result. The "field grouping" option in the menu of pivot table analysis is greyed out for some reason. Thats the...
You still have texts in the source table
Most probably values were returned by formula like =IF(1,number,""). Other words cells are not blank, they have empty string value. Even if in filter they are mentioned as Blanks
If select filter table on "blanks" only, press Del (other words clean such cells), refresh PivotTable, we will see that (blank) appears in it and grouping is available
Result is
In the source table of your sample file there was mix of numbers and texts. If keep only numbers grouping works
And it's better to switch off Show Formulas flag on ribbon.
In general it's doesn't matter the value was added to the cell manually or by formula.