Returning a label rather than a number in pivot table field

K

Kristian

I am new to pivot tables and have managed to create a few that show the
desired data.

However, I would like the value returned to be the name of a company rather
than a number. Is this possible?

For example, I have company types in the column (e.g. small & big) and
geographic location in rows (e.g. Europe & North America). The data shown in
the pivot table is minimum, maximum and average. However, I would like the
company name instead of the minimum value.

I know that I can right-click and show details, but that is all the data,
not just for the particular cell.

One other question, can I filter the data to exclude zero's? For example, in
the minimum field?
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
Pivot Table Data Aggregation 0
How to Create an S-Curve from Custom Field? 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Excel does not accept text format! 0
DATE Calculations in pivot table 0
Pivot Table Calculated Field 0

Top