Drill Down Problem

Hi Angelia,

Thank you so much for your reply.

However, I don't want the result shown in the third screenshot.

If we click the 'Expand all down one level in the hierarchy' I will get the third screenshot. That one I aware.

However now, when I right-click the bar and select drill down on the second screenshot. I get this third screenshot where I don't want. 

ie. When I right click and drill down China I get China Beijing, China Shanghai, etc. This one should happen when I click the third button from the left.

What I want when I drill down China, is to get Beijing, Shanghai, etc only.

Thank you so much.

I believe there is a bug.

Edit: when I retry new chart with same data and same hierarchy. It works perfectly. So I think this is a bug