Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Juneau, Alaska, USA
    Posts
    63
    Thanks
    0
    Thanked 1 Time in 1 Post

    Pivot tables custom calculation (2002 SP2)

    I'm trying to figure out how to display the data in the data area of a spreadsheet as a percentage of another field in my table. I have a column called enroll which contains enrollment numbers for classes (each row is a class), and another column named seats which contains the number of available seats in the classroom. I'd like the cells in my pivot table to show the percentage occupancy of the classroom or enroll / seats. The table shows enrollment by half-hour timeslots for each day (e.g., timeslots vertically down the side as: 9:30 AM, 10:00 AM, etc. and days across the top as Mon, Tue,etc.). It shows the enrollment numbers just fine. I put sum of enroll in the data area and pulled [/b] down the show data as list, where I selected as % and found seats in the Base field area. No matter what I select in the Base Item area, all my cells show #N/A. Please help!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Pivot tables custom calculation (2002 SP2)

    I am a little confused about your setup. could you post an example and possibly what numbers you EXPECT to get in a table along with your pivot table.

    Steve

Posting Permissions

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