'formula 1' appears in Pivot Table after grouping
 

Hi, when I use 'Group Selection' inside a pivot table, the words 'formula 1'
suddenly appear inside the data I am trying to group. and then if I am trying
to group say 10 rows of data, it only highlights 9 of them plus the row
beneath with the word 'formula 1' as the 10.. and the 10 data value appears
in the row below, but is excluded from the group. Any guidance please?
Thank you.

'formula 1' appears in Pivot Table after grouping
 

What is in the field you are trying to group and what type of field is it -
row, column or data field?

Usually when you apply the Group Selection command the word Group1 appears
in a new column of the pivot table, not the word Formula 1?

Do you have any custom Formula Items or Fields in your pivot table? And
what version of Excel are you using, it sounds like 2007.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"spudsnruf" wrote:

Hi, when I use 'Group Selection' inside a pivot table, the words 'formula 1'
suddenly appear inside the data I am trying to group. and then if I am trying
to group say 10 rows of data, it only highlights 9 of them plus the row
beneath with the word 'formula 1' as the 10.. and the 10 data value appears
in the row below, but is excluded from the group. Any guidance please?
Thank you.