I have a problem with a customer hierarchy. The structure of the data makes is it pretty tough in my opinion. Attached is some sample data. This is the correct result:
Highest Level
Upper level 2
Upper level
Customer
d300975
d200075
d200375
d300975
d200398
d1808
d300975
d200398
d26045
d300975
d200398
d26046
d200382
d22890
Is there a way to do that in QlikView? I also tried Hierarchy load but I couldn´t make it work.
