Using Pivot tables and extracting proper columns when double clicking

In the Image I uploaded I am trying to figure out 2 things. 1. Is it possible, without code, to double click on cell selected and not get those extra columns to show up because they are not needed? 2. Or must I use code and would the code be easy to accomplish this feat? I try to look this up but I honestly don't know how to properly search for it. I tried like 10 times but kept getting drill down information that turns the double click feature off however, I want to be able to double click and have the sheet come up that is on the right of the image. I am using office 365 So let me explain what I am asking real quick. I created a pivot table, if you double click on the number that is selected or 15 in the rifle qualification section I want it to bring up all the necessary information like peoples positions, ranks and names. However, I only want to bring up the Rifle date and the fact if they need or don't need to qualify. On the image to the right you can see I circled the columns I don't need like swim qual. I also would like to do the same thing but with swim qual date and level and don't need/ need columns but not see rifle qualifications. The two pivot table come from the same table. The Spreadsheet is attached as well.

Edit Mod :https://www.mrexcel.com/board/thread.../#post-5475242

You question is not fully clear to me, but to get you started.

See if this pivot table is what you want.

By clicking on a value in the pivot table it always shows all the information.

If you want just a small part of the information, you need to make the pivot table, from a data set without the unneeded information.


Why do you want this in an apart worksheet, since the data is in the original dataset?

Maybe if you re-arange format of the data.

See the attached file.

For the moment I run out of idea's on this one.

If you are satisfied with the solution, please mark the question solved.

You can add reputation by clicking on the star * add reputation.


If you like suggestions of other forummembers you can leave this question open.