Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm having a challenge with Pivot Tables. I'm not as well versed as I should be but am slowly learning their benefits.

    I have source data that I would like to create a Pivot similar to this from a data set but am not sure how. If a single User were selected than only the records with a "Y" would be displayed.

    User 01 User 02 User 03 User 04
    Report 1 N N N Y
    Report 3 Y N N N
    Report 5 N Y Y N
    Report 6 N Y N N
    Report 7 N Y N N
    Report 8 Y N N N
    Report 10 N N Y N


    I have attached a sample workbook.

    Thanks for your assistance,
    John
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    May 2008
    Location
    India
    Posts
    306
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='jstevens' post='787077' date='01-Aug-2009 05:30']I'm having a challenge with Pivot Tables. I'm not as well versed as I should be but am slowly learning their benefits.

    I have source data that I would like to create a Pivot similar to this from a data set but am not sure how. If a single User were selected than only the records with a "Y" would be displayed.

    User 01 User 02 User 03 User 04
    Report 1 N N N Y
    Report 3 Y N N N
    Report 5 N Y Y N
    Report 6 N Y N N
    Report 7 N Y N N
    Report 8 Y N N N
    Report 10 N N Y N


    I have attached a sample workbook.

    Thanks for your assistance,
    John[/quote]

    Pl have a look on attachment. Hope this will serve the purpose.
    Attached Files Attached Files
    Regards
    Prasad

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Your source data are not in a proper database-like format, and the "pivot table" is just the source data with rows and columns transposed.

    A pivot table doesn't display text data, it always displays summary data: a sum, count, min, max, ...

    Perhaps AutoFilter would be more suitable for your purpose.

Posting Permissions

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