If you've already attempted something along these lines, then you really need to post a packaged workbook so people can see how your data is structured, what you've attempted so far etc etc. Please see these articles for an explanation as to why we ask for this and how to do it
thank you for your response. I´m aware of the actions.
I think the problem is due to the filtering between the worksheets. Attached you can see the Worksheet 2. Here I get no values for segments and world. It is because Set 1 is showing all the items. When I filter it to 1 item it shows me values for the segments. So how can I filter dynamically on 1 item when I click on one on the Worksheet 1 for drill down?
I was able to narrow down the problem. It is due to the fact that for segment there are no values in periodic. Only on item level (Set 1). So do I have to write an mdx query or similar to solve this issue? And I want to have it only by selecting an item on worksheet 1 --> it should show me the values for the segment on worksheet 2.