Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Pivot Table (XP & 2003)

    I would like to create a Pivot Table where each row would fill with the appropriate data. Currently, like an out line, only the data fills in where there is no other detail. I am attaching a sample of a small data base and the pivot table as it was created in Excel and an illustrative table as I would like it. I highlighted the areas in red where I would like to see the pivot table insert the appropriate data.

    Thank you
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot Table (XP & 2003)

    Pivot tables don't work that way. You'd have to copy, then paste special the pivot table as values to another location, and fill down the values.

    If you really need the format you indicate, consider using Microsoft Access. It's not difficult to create a report in Access that looks the way you want.

Posting Permissions

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