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

 

[hobo_3]

following the step-by-step Alberto's article I arrive correctly to the creation and use of the measure CountOfNodeID (left image)
but when I use the measure called SumOfAmount I have the problem that appears in the right image:

 

[marco.russo]

You should just remove the "Somma di SumOfAmount" measure from the PivotTable.

 

[hobo_3]

if I remove that column I arrive to this view

]

 

[marco.russo]

You can apply the calculation described in a following blog post by Alberto: Alberto Ferrari : Parent/Child Hierarchies in Tabular with Denali

 

[hobo_3]

Thank you for being so helpful
tomorrow I'll try this new way

 

[hobo_3]

perfect!
now I have a clear hierarchy

thank you very much