hierarchy in PowerPivot

[hobo_3]

Hello everyone,
I apologize immediately for my bad English
I have a problem with the creation of a hierarchy.
below I will post a sample taken from the following link: Informazioni sulle funzioni per gerarchie padre-figlio in DAX - Excel - Office.com




in the powerpivot window I have created the columns from the third onwards;
after that I created the pivot table by inserting columns Level_1 to Level_5 in "row label"
the question: how can I view the hierarchy created without seeing all the empty spaces?
I hope I was clear
thanks to all

 

[marco.russo]

You can find a detailed example to solve the issue in this article from Alberto Ferrari: Alberto Ferrari : PowerPivot and Parent/Child hierarchies

 

[hobo_3]

I'm going to study it immediately
thanks a lot

 

[hobo_3]

Unfortunately... this solution will not work in my case

...any other advice?

 

[marco.russo]

If you can give us more information about why it doesn't work in your case, maybe we can give some other advice...

 

[hobo_3]

Article by Alberto Ferarri is a fundamental link with earnings of colleagues of the layers below.
I just need the representation of a parent-child hierarchy, where (the example I posted is simplified) I cases from 2 up to 8 levels below

 

[marco.russo]

Can you show a detailed example of what you want to obtain? It's still not clear to me.

 

[hobo_3]

What you see is my result
But I would like to disappear the blank lines (filters act on the PowerPivot does not work, also deletes the rows of interest)

 

[marco.russo]

The Alberto's article explains exactly this issue... you have to use the "hide empty rows" feature in Excel and a measure that put a blank in nodes you want to hide.

 

[hobo_3]

I've probably done something wrong, and I will try to redo the process from the beginning of the Alberto's article
I'll let you know the result
thanks