+ Reply to Thread
Results 1 to 7 of 7

Help with setting up a pivot table

  1. #1
    Registered User
    Join Date
    11-09-2019
    Location
    Milan, Italy
    MS-Off Ver
    office 365
    Posts
    23

    Help with setting up a pivot table

    Hello everybody, today I discovered the pivot tables. So I decided to give it a try. Now I have encountered a problem which I cannot solve. I have looked everywhere for an answer but could not find it. So I guess the problem lays in the way I set up the table.
    Attached please find the table I am working on. What I am trying to achieve is the following:
    When I select a collection I need to see which artefacts are part of it (maybe ordered by lvl), the xp they give, the amount of chronos they give and... here comes the problem: I only need to see which materials are needed for that specific collection, the columns that have no values should be hidden. I also include a manually generated example of the required outcome.

    Thanks for any help you can provide
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    47

    Re: Help with setting up a pivot table

    Hi there,
    See if the Pivot table on the workbook is what you are after.
    I have renamed the first 3 materials; removed the 'Sum of'. Note, the name can't be the name of the table heading, so I left the 'space' in front. You could make some other difference..
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-09-2019
    Location
    Milan, Italy
    MS-Off Ver
    office 365
    Posts
    23

    Re: Help with setting up a pivot table

    Hi ORoos, yes, this is what I am looking for. Just one last question: if for some artefatct I don't need some materials, is it possible NOT to show the column?

  4. #4
    Registered User
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    47

    Re: Help with setting up a pivot table

    Hi s7yzrs,

    Don't think you can do that with the actual pivot table. But a simple VBA code can do it.
    I entered the code into Sheet1 to trigger each time the pivot table is updated (a new selectin is made).

    Please Login or Register  to view this content.
    I have also added a 'Slicer' in column A. This makes the selection of your Collection(s) a bit easier.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-09-2019
    Location
    Milan, Italy
    MS-Off Ver
    office 365
    Posts
    23

    Re: Help with setting up a pivot table

    Wow, I am impressed. I had no idea that pivot tables could do this much. Thank you for your help. I will analyze what you sent me and try to understand it.
    Again, thank you very much indeed.

    I just wish I could find the "solved" button to close the topic....

  6. #6
    Registered User
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    47

    Re: Help with setting up a pivot table

    Glad I wsa of some help.

    To mark your thread solved do the following:
    New Method
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    Old Method
    - Go to the first post
    - Click edit
    - Click Advance
    - Just below the word "Title:" you will see a dropdown with the word No prefix.
    - Change to Solve
    - Click Save

  7. #7
    Registered User
    Join Date
    11-09-2019
    Location
    Milan, Italy
    MS-Off Ver
    office 365
    Posts
    23

    Re: Help with setting up a pivot table

    Great.... thank you again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1