Pivot chart drill down

[franzreif]

Hi,
I have a problem with the drill down on a pivot chart. Normally I would expect that it shows the underlying data that leads to the number I can see in the pivot chart. But when I do the drill down it just shows me the number of rows of the biggest amount in the pivot chart row.
Is there a mistake in my logic? Or if it's correct is there a way to filter the drill down with a makro so it will just show the underlying data? I understand that the colums in the pivot chart are sums but how can I just drill down to the rows that have a "1" in the cells of the drill down.

Here is an example fil. If you click e.g. on the "6" in cell H7 of the "Categories" worksheet you will : http://workupload.com/file/tVCaZMdI

Thanks and regards
Franz

P.S.: Tell me if I should explain something in more detail (I'm using Excel 2013 and I'm not a native English speaker)

 

[konew1]

You are drilling down to show all the rows that have Wheels as main group. Some of the rows have zero in the "week 3" data column, but those zeros are being included in the sum totalling 6 and so are reported in the drill down

 

[franzreif]

Are they as well included if I replace the zeros with an empty cell? Or is there any other way to just show the cells that have a "1" in them?

 

[konew1]

What you are doing is not full functioning pivot. The same thing could be achieved by autofilter or sorting the data and putting in subtotals. I don't know how you can hide the zero on pivot, easy on autofilter

 

[franzreif]

Thanks!
I found a solution with makros that seems to work for me. What it basically does is that it will filter the drill down worksheet so that it just shows the rows that include a "1" in the column I did the drill down. here is the lunk to the solution:
Excel 2010: Double-Click PivotTable Item without Displaying Excess - Microsoft Community