Split Hierarchy into columns and remove unrequired lines

[former_member285724]

Hi!

I am building up a report to split hierarchy levels into columns so I can use it in my datamart. I have been able to split it out into different columns, the hieirachy is for materials. The only Issue is that when I attach the Material key to the levels table the Node name 's shows up thus adding extra lines to the report. When I try filtering out the non numeric values from the columns the other level columns value disappear, I just want to show the materail numbers and not the text from the Hierarchy Node name.

My Report looks like below:

What I want to be able to do is have the rows with Technical text values be removed from the table, if I use filter it blanks the different level columns as there is a variable calculating the depths of the hierarchy to get values. Is there a way to do so?

WEST _MATERIAL_2 Material - Key Material Level 1 Material Level 2 Material Level 3 Material Level 4 Material Level 5 Service SERVICE Service Service Service Service Service Services SERV_SERVICES Service Services Services Services Services Equipment Rental SERV2_EQUIP_RENTAL Service Services Equipment Rental Equipment Rental Equipment Rental Centrifuge CENTRIFUGE Service Services Equipment Rental Centrifuge Centrifuge Centrifuge, Lynx 20FMVB, Rental 000000000000075400 Service Services Equipment Rental Centrifuge Centrifuge, Lynx 20FMVB, Rental COPPER STRING 000000000000074701 Service Services Equipment Rental Centrifuge COPPER STRING Centrifuge, H-H5500FV, Rental, TEMPORARY 000000000000074702 Service Services Equipment Rental Centrifuge Centrifuge, H-H5500FV, Rental, TEMPORARY Tote Cleaning & Disposal 000000000000070283 Service Services Equipment Rental Centrifuge Tote Cleaning & Disposal Lab Testing Services 000000000000070313 Service Services Equipment Rental Centrifuge Lab Testing Services Truck Tank Flushing - Service 000000000000070314 Service Services Equipment Rental Centrifuge Truck Tank Flushing - Service Subsistence - Newalta Employee 000000000000070315 Service Services Equipment Rental Centrifuge Subsistence - Newalta Employee

[former_member285724]

Putting the values again