Pivot Table

D

Django

I am working on a Pivot Table in which I am trying to add another column.
Whenever, I add the column it goes to the right. So I go into the Pivot Table
Field List and select "Move to Values" which moves it to the right where I
want it. However, in the Column Heading instead of "FY 2008", it has "Count
FY 2008". Can anyone tell me how to get rid of the count? Appreciate any help
that you can provide.
 
G

Gregzilla

Did you try going into the cell with the column heading, right clicking the
mouse, going to Field settings, and changing the "custom name" field to the
name you want?
 
D

Django

That is easy enough, however, instead of bringing in the data in the fields
it seems to be counting them.
 
G

Gregzilla

If you go to field settings you should see three options: automatic, none,
and custom in Subtotals & Filters tab. Select custom and you should be able
to change it from count.
 

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

Top