How to rename a GROUP in a Pivot table

S

spudsnruf

Hi, trying to rename a GROUP in a Pivot table. eg I have 3 groups which are
for 3 yrs sales, 2007, 2008 and 2009. In the pivot table, they are just named
group 1,2,3. Is it possible to rename them to the date or something or more
useful? Thank you
 
T

tpeter

Hello,

If you have access to the core data table that the Pivot Table is building
from all you have to do is change the header name to what you want and then
refreshe your pivot table. It may drop your field out but you can always put
it back in.

Tim
 
S

Shane Devenshire

Hi,

Just click on the word Group1 and type a meaningful name on top of it. The
only names that are not legal are ones that match already existing fields.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table: deleted source data 1
Unable to Group in Pivot Table 1
Pivot Table Chart - Group Totals 1
rename groups in Pivot table 1
Formatting pivot chart axis labels for dates 10
Changing Pivot Table Data Source to multiple ranges 1
How to ignore a column of numbers in Grand Total for rows 1
Average of Subtotals in Pivot Table 0

Top