Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
M stuck off facing this problem. here's an example
like i have a table
LOAD * INLINE [
Name, Flag
A, 1
B, 2
C, 3
D, 3
E, 3
F, 2
G, 3
H, 3
];
I want output as alike hierarchy wise on basis of flag
so, in pivot i want this
Level1 Level2 Level3
A B C
D
E
F G
H
here, when i expand A then it gives all data of Level2 and Level3
but when i expand Level2 F value it gives G and H in Level3
Any help will be appreciated.
Hi Mohit,
Please see if the attached file helps you.
You might want to take a look at this article as well: Hierarchies
Best Regards,
Nilo
Please help me here i want
in three separate field
Level1 gives value A
level2 gives B and F
Level 3 gives C,D,E,F,G,H
here in level2 if i select B then in Level3 gives C,D,E
when i select F value in Level2 then it gives F,G,H
or if can't possible please suggest me how to make Correlated flag in data source so, that it can give like this output
Hi Mohit,
Please see if the attached file helps you.
You might want to take a look at this article as well: Hierarchies
Best Regards,
Nilo
HIERARCHY(NodeID, ParentID, Node)
LOAD
Flag as NodeID,
Flag-1 as ParentID,
Name as Node;
LOAD * INLINE [
Name, Flag
A, 1
B, 2
C, 3
D, 3
E, 3
F, 2
G, 3
H, 3
];
PFA