Forum Discussion

Michel12345's avatar
Michel12345
Copper Contributor
Aug 09, 2020
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...
excel
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 10, 2020

    Michel12345 

    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's avatar
SergeiBaklan
Diamond Contributor
Aug 09, 2020

Michel12345 

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.

Michel12345's avatar
Michel12345
Copper Contributor
Aug 09, 2020

SergeiBaklan 

 

Thanks.

 

Yes that can be a problem it seems. And yes there is text in the example file. Maybe that was a bad example, because if i delete text from cells the problem still exist. 

 

I added a new example file without text. It would be nice if you can find the fix needed! Thanks!


Regards,

Michel