Forum Discussion
Field grouping/grouping not working in pivot table
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
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
SergeiBaklan Make sure that you do not check the Add to Data Model checkbox. This will allow your data to be grouped.
Actually the question was not why grouping is not available, but why it doesn't work as expected.