Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jun 2005
    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
    Thanked 31 Times in 31 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