Code
Name
tbd
04.1 Group1
04.2 Group 2
10.1 group1
10.2 group 2
10.3 group 3
11.1 group1
11.2 group 2
12.1 group1
12.2 group2
12.3 group3
12.4 group4
12.5 group5
03
4 rounded_nominated
64
03
3 rounded_nominated
99
03
2 rounded_nominated
82
03
1 rounded_nominated
67
03
0 rounded_nominated
62
04
4 rounded_nominated
6
11
04
3 rounded_nominated
35
38
04
2 rounded_nominated
10
28
04
1 rounded_nominated
6
9
04
0 rounded_nominated
3
18
24
10
4 rounded_nominated
12
10
2
5
10
3 rounded_nominated
7
9
12
9
10
2 rounded_nominated
2
9
8
5
10
1 rounded_nominated
1
10
0 rounded_nominated
7
4
4
11
4 rounded_nominated
23
7
11
3 rounded_nominated
1
40
42
11
2 rounded_nominated
3
19
20
11
1 rounded_nominated
6
9
11
0 rounded_nominated
6
9
11
12
4 rounded_nominated
30
30
37
22
17
12
3 rounded_nominated
3
103
48
31
37
84
12
2 rounded_nominated
46
28
8
25
39
12
1 rounded_nominated
7
2
1
8
5
12
0 rounded_nominated
15
16
2
13
10
21
FirstRow
Warn
[Code:A]
Basic
100%
Basic Table
pdf
Layout
Continuous
1
squeeze
warning
PerRecord
V
Continuous
100%
0
Vertical Layout
Each Individual Record
Looking for a way to dynamically select the columns which have the first two digits matching the Code column as well as the default columns (name and tbd)
Want to avoid filtering each value
[Code] = "03"
Simple
=
Code
True
fixed
2019-09-23 09:46:08
0
2019-09-23 09:46:08
2019-09-23 09:46:08
03
[Code] = "03"
[Code] = "04"
Simple
=
Code
True
fixed
2019-09-23 09:46:08
0
04
2019-09-23 09:46:08
2019-09-23 09:46:08
[Code] = "04"
Horizontal
Dynamic select of columns