A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

'formula 1' appears in Pivot Table after grouping



 
 
Thread Tools Display Modes
  #1  
Old September 3rd, 2009, 10:39 PM posted to microsoft.public.excel.charting
spudsnruf
external usenet poster
 
Posts: 49
Default '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  
Old September 5th, 2009, 05:19 AM posted to microsoft.public.excel.charting
Shane Devenshire[_3_]
external usenet poster
 
Posts: 3,333
Default '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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.