Pivot Table ShowDetail (Double Click) shows too many entries

Got this issue today, and haven't been able to solve it. Data looks similar to what you see below. I am creating a Pivot Table out of this, and use SUM as a Field Setting. When double clicking the data, i get more records than i am expecting. Even though England - Bronze shows 5 on PT, all 8 show up. What is the best way around this? Am i missing a simple PT setting? Or will i need to code some crazy VBA getpivotdata/doubleclick/showdetail module? Thanks in advance!

Event Country Bronze Silver Gold
1 England 1 1 0
2 England 0 0 1
3 England 1 1 0
4 England 1 1 1
5 England 0 0 0
6 England 1 0 0
7 England 0 1 1
8 England 1 1 1
9 Russia 0 0 0
10 Russia 1 1 1
11 Russia 1 1 1
12 Russia 0 0 1
13 Russia 1 1 1
14 Russia 0 0 1
15 Russia 0 1 1
16 Russia 0 1 1
17 Russia 0 0 1
18 Ethiopia 1 1 0
19 Ethiopia 1 0 0
20 Ethiopia 0 0 0
21 Ethiopia 1 1 1
22 Ethiopia 1 1 1
23 Ethiopia 0 0 0
24 Ethiopia 1 0 0
25 Ethiopia 1 1 1
26 Ethiopia 0 1 0
27 Ethiopia 1 1 0
28 Ethiopia 1 1 1
29 Ethiopia 0 0 1
30 Ethiopia 1 1 0
31 Ethiopia 1 1 1
32 USA 0 0 1
33 USA 0 1 1
34 USA 1 0 0
35 USA 1 0 1
36 USA 0 1 0
37 USA 0 0 1
38 USA 1 1 0
39 USA 1 1 1
40 USA 0 0 1
41 USA 1 1 0
42 USA 1 0 0
43 USA 1 1 1

Yes, double clicking the 5, i also get 8 rows of data, but i only want to see the 5 that are part of the pivot table.

Right, but I've got 40k lines down vs 120 0/1 fields that i have to sift through, i might have an idea, stitching a bunch of PTs together.

@ marvinp, that's not what i am looking for, but thanks for the try. The actual case i am working on has nothing to do with medals, i just used that as an example. i need to be able to sum every country's medals, and on the double click get the correct data to show up. i can't use those fields as filters, because Excel treats them as "AND", and not "OR" filters. Filtering out where Bronze = 0 automatically removes every entry where Bronze = 0 (even if that entry had Silver = 1, or Gold = 1), not just the entries under that Country. The right thing here is to have a one-to-many relationship, but that is 40k lines x 120 0/1 flags = 4.8 million lines. I was hoping there was an easy solution, but alas

Originally Posted by oljasmn

Yes, double clicking the 5, i also get 8 rows of data, but i only want to see the 5 that are part of the pivot table.

Hello Oljasmn, When you double click on a number in the values side of a pivot table it gives you all the data of related row label. In this case when you double click it gives you all the information related to that row label (England). This row label appeard 8 times in raw data set so despite you clicking on Value (Bronze 5) its giving you full info. You will get the same result if you click on Gold or silver value of current row label. If you go down to H4 and double click you will notice that you are getting all the information related to that row label.
This feature comes handy when source data is not available with the pivot table and you want to look into it. This feature also helps when you want to present or share a quick report with data limited to one row label.
Hope this information helps.
Best Regards/VKS