Hierarchy and dependency

[Redda_joppe]

Hi
I have a set of data where I like to collect all data like in a pivot table but I like to choose as follows
Project no
Project sub

The city will be related on country. So only cities related to country are visible in the drop down menu

I have tried with power pivot, but I don’t quite get it to work

 

[Peter_SSs]

Duplicate to: Pivot table

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.