pivot table manipulation
 

Hi all.
I have a pivot table made up, but I need to do 5 or 6 steps for the
final presentation.
Basically I have different columns that are categories of Land Use
Zoning for Sacramento County. I have on the left side of my table the
name of various projects(The Falls, Kamilos Gates, etc...). I need to
be able to figure out the acreage of the Land Use Zones for each
project. I have the acreages made up for each project for each type of
Land Use.
For example, Kamilos gates has 2 land uses, RD1-2(Residential Density
1-2 units/acre), RD2-5(Residential Density 2-5 units/acre).
Now, these numbers have to be mulitplied by a preset number (made up
the by the County Planning dept.) For the RD1-2 column the mulitplier
is .66, to get a "Dwelling Unit Count".
So how do I make up a new column that will contain the product?
I know this is complex, but any ideas would be helpful.
Thx,


--
araki
------------------------------------------------------------------------
araki's Profile: http://www.excelforum.com/member.php...o&userid=15334
View this thread: http://www.excelforum.com/showthread...hreadid=517886

pivot table manipulation
 

In a new worksheet, list in column A all the names like ..
RD1-2(Residential Density 1-2 units/acre) etc
In column B enter the value (ie number) that relates to each name (eg
.66)

Back on the worksheet that contains the data from which you create the
pivot table, add an extra column (in the pivot table data range) and
use Vlookup to get the value that relates to that name. If you have a
qty times a value that you need to sum then create that column also to
avoid having to create a calculated field.

I hope I understood your question correctly.

regards..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=517886