Pivot Table "look"
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 particular Property. *and* by the type of landscape it has(ie grass, gravel) by it's Parcel number. that is easy. *However*, I would like to get the Owner Name, Address, and Zip in the fields beside it. But when i make my pivot table, I put the owner and adress in the data field, it just gives the COUNT of types of landscape. I want the actual owner. Am I going in the wrong direction here? I'm on excel 2000 and thx -- araki ------------------------------------------------------------------------ araki's Profile: http://www.excelforum.com/member.php...o&userid=15334 View this thread: http://www.excelforum.com/showthread...hreadid=567444 |
Pivot Table "look"
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. "araki" wrote: 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 particular Property. *and* by the type of landscape it has(ie grass, gravel) by it's Parcel number. that is easy. *However*, I would like to get the Owner Name, Address, and Zip in the fields beside it. But when i make my pivot table, I put the owner and adress in the data field, it just gives the COUNT of types of landscape. I want the actual owner. Am I going in the wrong direction here? I'm on excel 2000 and thx -- araki ------------------------------------------------------------------------ araki's Profile: http://www.excelforum.com/member.php...o&userid=15334 View this thread: http://www.excelforum.com/showthread...hreadid=567444 |
All times are GMT +1. The time now is 03:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com