If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
'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. |
#2
|
|||
|
|||
'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. |
Thread Tools | |
Display Modes | |
|
|