Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    pivot table structure (2003)

    I would like to have a data set create a pivot table which would look something like the pivot table format shown on worksheet "pivot table format". I generally have the data structred as shown on the "data" worksheet; e.g., with time in column A and the data for the times in several subsequent columns. When I try to create a pivot table from the data set, it ends up looking like the PT shown in worksheet "PT".

    What would be the correct way to structure the data and create the pivot table to get the results in the format that I want?

    Thanks.
    Attached Files Attached Files

  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 table structure (2003)

    Move the Mouse pointer over "DATA" Header in the PT.
    Left-click and hold and drag it slowly over to the "Total" column.
    When you see a small "graphic" of the data in "column format" (the left and bottom side of the total will be highlighted with a dashed border) let go of the left button.

    The data format will be as pictured. Change the labels if desired (though you can not duplicate the existing field names)

    Steve

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: pivot table structure (2003)

    Wow!
    sometimes the simple way works.
    Thanks for the help

Posting Permissions

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