Pivot-How to add field value to already made group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
(e-mail address removed)
 
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
 
Ann

No, unfortunately you need to ungroup and group...more care ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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.
 
Back
Top