I have a requirement where I have to show the data in treeview.
Attached is the sample data.
NodeID
ParentID
Value
Overall_Percentage
Within_Percentage
Level
Filter1
Filter2
1
Value1 has Overall 99.57 and within 100
99.57
100
1
10
0
2
Value2 has Overall 87.46 and within 38.47
87.46
38.47
1
12
0
3
Value3 has Overall 39.36 and Within 37.26
39.56
37.26
1
12
1
4
1
Value4 has Overall 14.49 and within 29.38
14.49
29.38
2
11
1
5
2
Value 5 has Overall 46.56 and Within 47.38
46.56
47.38
2
10
0
6
1
Value6 has Overall 75.68 and Within 43.57
75.68
43.57
2
12
0
7
2
Value7 has Overall 96.56 and Within 49.29
96.56
49.29
2
10
0
8
3
Value8 has Overall 56.89 and Within 19.99
56.89
19.99
2
11
1
9
3
Value9 has Overall 36.46 and Within 47.66
36.46
47.66
2
12
1
10
2
Value10 has Overall 38.26 and Within 1.47
38.26
1.47
2
11
1
11
5
Value11 has Overall 90.35 and Within 3.33
90.35
3.33
3
10
0
12
4
Value12 has Overall 27.36 and Within 59.66
27.36
59.66
3
12
1
13
9
Value13 has Overall 99.87 and Within 9.27
99.87
9.27
3
10
0
14
5
Value14 has Overall 32.46 and Within 10.23
32.46
10.23
3
10
0
15
10
Value15 has Overall 35.47 and Within 13.3667
35.47
13.3667
3
11
1
16
7
Value16 has Overall 42.16 and Within 27.38
42.16
27.38
3
12
1
17
8
Value17 has Overall 53.89 and Within 47.27
53.89
47.27
3
10
0
18
9
Value18 has Overall 65.27 and Within 1.33
65.27
1.33
3
12
0
19
7
Value19 has Overall 82.46 and Within 3.58
82.46
3.58
3
11
1
20
9
Value20 has Overall 61.36 and Within 19.26
61.36
19.26
3
12
0
I have to filter/select the data based on an range of Percentage (Overall_Percentage field to be used)
First it should filter on level 1 then on Level 2 and then on Level3.
I have selected the range >80.
The result is coming out to be
Expected is :
If the Overall_Percentage range is available in Level=1 then only it should show value at Level=1 else not (Value3 and its tree beyond should not be shown),
if the Overall_Percentage range is available in Level=1 first and then Level=2 then it should show value at Level=2 else not (Value5 and its tree beyond should not be shown),
if Overall_Percentage range is available in Level=1 and then Level=2 and then Level=3, then its should show the Value at Level=3