Pivot Table "look"

A

araki

Hi all.
I am trying to make a pivot table that has a 2 functions.

In one column, I want the find sum all the acreages for a particula
Property.
*and* by the type of landscape it has(ie grass, gravel) by it's Parce
number. that is easy.

*However*, I would like to get the Owner Name, Address, and Zip in th
fields beside it. But when i make my pivot table, I put the owner an
adress in the data field, it just gives the COUNT of types o
landscape. I want the actual owner.

Am I going in the wrong direction here?

I'm on excel 2000 and th
 
G

Guest

They are text files, so for showing their values they should be in the
rows/columns/page area. In the data area only numbers are displayed.
Drag the fields on the rows or the columns instead, and check what layout
fits you more.

Hope this helps,
Miguel.
 

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