Pivot-How to add field value to already made group

A

AnnP

If I have already grouped values in a Pivot is there a way I can add an
additional value without ungrouping and then selecting everything plus the
value I left out and then grouping again.

I hate having to undo my group when I accidently left out a value.

Thanks for any help with this.
 
N

Nick Hodge

Ann

Not quite with you as I can think of two things you may have done. If the
data is external just refresh it and it should get included without anything
happening to the grouping.

If it is Excel data on another sheet, just add the data to the bottom and
then go to the pivot table, invoke the wizard and press 'back' at the first
screen you get and extend the data range to include the new rows and then
refresh the pivot

Hoped I understood with one of these

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
A

AnnP

Nick,

My message was not clear.

I have used a field as a row in my Pivot Table and the values for that field
show up as rows. I then select on the values I want to group right click and
select Group.

What I am trying to do is not have to right click on the group and Ungroup
then do the whole Group again because I left a value or values out of the
group I made.

Does that make more sense. All of my data is in the Excel table etc.

Thanks.

I would like to use my existing group and just add a value
 
K

Ken Wright

Your call, you can always select the existing group and the new record and
then group those and just drag the old group off the table. Not neat and
tidy but one way of handling it.

You could also just add another column to the data table and then put a flag
in there to group all the items you want and then drag that field in to your
table.
 
Top