Pivot Table showing number "1" instead of actual result

  • Thread starter Thread starter Pendelfin
  • Start date Start date
P

Pendelfin

Hi
I have a pivot table that I constantly update the data for but when this is
refreshed on the cells that should show "Known As" I am seeing a number "1"
instead .
I have tried various ways around this by changing the data page to rename
this to re-creating the data page but it is always an issue.
Does anyone have any suggestions.
Many Thanks in advance for your responses
 
It sounds like you have the "Known As" field in the Data section of the
Pivot Table Layout, instead of in the Row section. Consequently, you'd see
the count of the item.

Does that help?

Regards,

Ron
Microsoft MVP - Excel
 
You must log in or register to reply here.

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 - Changes 5
pivot table data 2
pivot table chart 7
Pivot Table Shows Only Zeros 3
Question on the occupied field of the pivot table in excel spreadsheet 0
refreshing data in a pivot table changes cell format 1
Pivot table 1
Pivot Table Page Break Refresh Problem 0

Back
Top