+ Reply to Thread
Results 1 to 2 of 2

pivot table manipulation

Hybrid View

  1. #1
    Registered User
    Join Date
    10-15-2004
    Location
    California, USA
    MS-Off Ver
    2016
    Posts
    42

    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,

  2. #2
    Forum Contributor
    Join Date
    01-23-2006
    Posts
    194
    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..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1