Forum Discussion

gitop's avatar
gitop
Regular Visitor
10 years ago

Drill Down - How to prepare the data?

Hello guys,   My situation:   I have an excel sheet with the follow rows (attachment „DataSource.xlsx) The Hierarchy for e.g Code 1 and the same structure for Code 2 Passiven I want...
Need Help
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
10 years ago

You need to have columns in your table, one for each level of the hierarchy. You can then either manually add each column, one at a time, to the visualisation, or create a hierarchy in the data model. 

gitop's avatar
gitop
Regular Visitor
10 years ago

Hello,

 

So I tried and didn't get the result I wanted:

Diagram:

 

What do I wrong?