Hello,

I am using Pivot Tables in Excel. I am trying to group my data (which I can
do), but the Grouping dialogue box does not appear. It just groups the data -
creating a another field (column) with the grouping. I would like to specify
the grouping range and not have to do it manually!

~jess

If you right-click on the field heading button, and choose Group and
Show Detail Group, you should see the dialog box.
If you have multiple cells selected, and right-click on those cells, it
will group those items without showing the dialog box.

jessica.lalonde wrote:
Hello,

I am using Pivot Tables in Excel. I am trying to group my data (which I can
do), but the Grouping dialogue box does not appear. It just groups the data -
creating a another field (column) with the grouping. I would like to specify
the grouping range and not have to do it manually!

~jess


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Hi!

Thank you! Another thing that was messing it up:
From the selected data there were blank cells, and when those were included
in the selection the Grouping dialogue box would not appear. When I removed
the records with the blank cells (or entered 0), then the dialogue box
appeared.

~jess

"Debra Dalgleish" wrote:

If you right-click on the field heading button, and choose Group and
Show Detail Group, you should see the dialog box.
If you have multiple cells selected, and right-click on those cells, it
will group those items without showing the dialog box.

jessica.lalonde wrote:
Hello,

I am using Pivot Tables in Excel. I am trying to group my data (which I can
do), but the Grouping dialogue box does not appear. It just groups the data -
creating a another field (column) with the grouping. I would like to specify
the grouping range and not have to do it manually!

~jess


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html