Pivot Table Help
Results 1 to 8 of 8
  1. #1
    Swarm & Punish
    Points: 291,742, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 22.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    keepngoal's Avatar
    Join Date
    Jun 2006
    Posts
    20,404
    Points
    291,742
    Level
    100
    Thumbs Up
    Received: 750
    Given: 1,558

    Pivot Table Help

    I am hoping someone could help me with creating a pivot table in Excel.

    I have a list of associations (4), that host tradeshows (10), cost associations with each tradeshow, month they happen and a total for the cost.

    I would like to have a pivot table that lists these left to right in the order above AND show the cost in the correct month. I have attached a sample Excel file illustration how i would like it laid out. Where I can expand/sort by association and/or tradeshows and/or costs.

    If you need more information, please let me know .... I might not be giving you all that you need.

    Thanks in advance.

    -keep


    The first and best victory is to conquer self; to be conquered by self is of all things most shameful and vile. - Plato

    May you only need 39 acres to turn your rig around. - keep

  2. #2
    Speechless
    Points: 562,939, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 3.0%
    Achievements:
    Social50000 Experience PointsOverdriveVeteranRecommendation Second Class
    ISUAgronomist's Avatar
    Join Date
    Nov 2009
    Location
    Back in Iowa!!!!!!!!
    Posts
    21,532
    Points
    562,939
    Level
    100
    Thumbs Up
    Received: 407
    Given: 201

    Re: Pivot Table Help

    Here's what I put together quickly. Not sure right now how to get individual cost in there without making the pivot table massive.



  3. #3
    Swarm & Punish
    Points: 291,742, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 22.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    keepngoal's Avatar
    Join Date
    Jun 2006
    Posts
    20,404
    Points
    291,742
    Level
    100
    Thumbs Up
    Received: 750
    Given: 1,558

    Re: Pivot Table Help

    nice. I wouldn't have the itemized costs showing all the time, but would need to expand a a particular tradeshows itemized costs or an associations costs... possible?


    The first and best victory is to conquer self; to be conquered by self is of all things most shameful and vile. - Plato

    May you only need 39 acres to turn your rig around. - keep

  4. #4
    Swarm & Punish
    Points: 291,742, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 22.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    keepngoal's Avatar
    Join Date
    Jun 2006
    Posts
    20,404
    Points
    291,742
    Level
    100
    Thumbs Up
    Received: 750
    Given: 1,558

    Re: Pivot Table Help

    can the months be fixed so the months aren't listed in the pivot table, are chronological?


    The first and best victory is to conquer self; to be conquered by self is of all things most shameful and vile. - Plato

    May you only need 39 acres to turn your rig around. - keep

  5. #5
    Speechless
    Points: 562,939, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 3.0%
    Achievements:
    Social50000 Experience PointsOverdriveVeteranRecommendation Second Class
    ISUAgronomist's Avatar
    Join Date
    Nov 2009
    Location
    Back in Iowa!!!!!!!!
    Posts
    21,532
    Points
    562,939
    Level
    100
    Thumbs Up
    Received: 407
    Given: 201

    Re: Pivot Table Help

    With individual costs they can be dropped individually in the (sigma) "value" box. The sorting of the months is strange. Seem to be fixed due to tradeshow order.



  6. #6
    Swarm & Punish
    Points: 291,742, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 22.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    keepngoal's Avatar
    Join Date
    Jun 2006
    Posts
    20,404
    Points
    291,742
    Level
    100
    Thumbs Up
    Received: 750
    Given: 1,558

    Re: Pivot Table Help

    Thanks! I really appreciate it.

    I was hoping the costs would show vertically and display in the current month, versus adding to the horizontal. So a tradeshows cost can be hidden/shown underneath the tradeshow. Possible?

    I really appreciate the help as I am lacking grey matter to learn pivot table tonight.

    -keep


    The first and best victory is to conquer self; to be conquered by self is of all things most shameful and vile. - Plato

    May you only need 39 acres to turn your rig around. - keep

  7. #7
    Speechless
    Points: 562,939, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 3.0%
    Achievements:
    Social50000 Experience PointsOverdriveVeteranRecommendation Second Class
    ISUAgronomist's Avatar
    Join Date
    Nov 2009
    Location
    Back in Iowa!!!!!!!!
    Posts
    21,532
    Points
    562,939
    Level
    100
    Thumbs Up
    Received: 407
    Given: 201

    Re: Pivot Table Help

    Seems like for that to work the costs (and corresponding data) would need transposed so costs are listed in a column similar to months. It's certainly possible but I'm not sure exactly how it would work while maintaining the connection to months. I'm having similar cognitive issues with it this late. Pivot tables certainly can be powerful but a PITA to get set up correctly.



  8. #8
    Swarm & Punish
    Points: 291,742, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 22.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience Points
    keepngoal's Avatar
    Join Date
    Jun 2006
    Posts
    20,404
    Points
    291,742
    Level
    100
    Thumbs Up
    Received: 750
    Given: 1,558

    Re: Pivot Table Help

    thanks for your help tonight.


    The first and best victory is to conquer self; to be conquered by self is of all things most shameful and vile. - Plato

    May you only need 39 acres to turn your rig around. - keep

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • TV: Cyclones.tv
  • HOOPS: Iowa State vs. Mississippi Valley State
  • December 31, 2014
  • 06:00 PM