How do I get the grouping dialogue box to appear in Pivot Tables?

[Guest]

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]

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.

 

[Guest]

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