Drill Down - How to prepare the data?

Question

Hello guys,&nbsp;My situation:&nbsp;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 PassivenI want to be able to drill down through the Code in this way:1. Aktiven&nbsp;&nbsp;&nbsp; a. 10 - Umlaufvermögen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i. 100 - Flüssige Mittel…&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1. 1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2. 1001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3. 10102. Passiven&nbsp;&nbsp;&nbsp; a. 20 - …&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; i. 200 - …&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; 1. 2000 - …&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2. 2001 - …&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3. 2002 - …The diagram visualization:&nbsp;How do I have to structure my excel sheet to able to drill down?&nbsp;Regards,gitop

mattallington · Answer

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.&nbsp;

gitop · Answer

Hello,&nbsp;So I tried and didn't get the result I wanted:Diagram:&nbsp;What do I wrong?

mattallington · Answer

You haven't filled the data in your table. &nbsp;Your hierarcy values need to be repeated on every row in every column. &nbsp;You can't leave blanks in your source table. &nbsp;Every cell in columns H1 through H4 must have a value - even if it is the same value all the way down the column.

Forum Discussion

Drill Down - How to prepare the data?

3 Replies

Related content

Preparing data for data agent

Data preparation

Preparing Enterprise Data Warehouses for AI-Powered Applications

Preparing a pricelist - products and assemblies

Sankey Chart Data model Preparation