Forum Discussion
Relationship between Multiple Tables
The Rest of my Example Data:
Table 2:
_Join Colum | Startzeit |
0_1252655 | 29.01.2022 01:40 |
0_1252918 | 28.01.2022 19:58 |
0_1253163 | 28.01.2022 17:48 |
0_1262976 | 28.01.2022 16:19 |
0_1263275 | 26.01.2022 00:41 |
0_1263555 | 25.01.2022 22:47 |
0_1279016 | 25.01.2022 14:50 |
0_1279248 | 25.01.2022 08:26 |
0_1279379 | 22.01.2022 01:49 |
0_1279594 | 21.01.2022 19:53 |
0_1291667 | 21.01.2022 16:26 |
0_1291952 | 21.01.2022 14:48 |
0_1292204 | 21.01.2022 13:21 |
0_1304480 | 21.01.2022 10:42 |
0_1304714 | 21.01.2022 00:18 |
0_1304922 | 02.12.2021 01:22 |
0_1316566 | 01.12.2021 23:47 |
0_1252655 | 01.12.2021 22:16 |
0_1252918 | 01.12.2021 01:13 |
0_1253163 | 30.11.2021 20:41 |
0_1262976 | 26.11.2021 23:32 |
0_1263275 | 26.11.2021 01:40 |
0_1263555 | 25.11.2021 23:56 |
0_1279016 | 25.11.2021 03:18 |
0_1279248 | 23.11.2021 12:00 |
0_1279379 | 23.11.2021 09:41 |
0_1279594 | 23.11.2021 07:17 |
0_1291667 | 19.11.2021 12:33 |
0_1291952 | 19.11.2021 10:36 |
0_1292204 | 18.11.2021 09:17 |
0_1304480 | 16.11.2021 21:34 |
0_1304714 | 12.11.2021 13:18 |
0_1304922 | 11.11.2021 17:10 |
0_1316566 | 11.11.2021 14:22 |
Table 3:
Time List | Datum & Uhrzeit |
29.01.2022 01:40 | 29.01.2022 01:45 |
28.01.2022 19:58 | 28.01.2022 19:40 |
28.01.2022 17:48 | 28.01.2022 17:40 |
28.01.2022 16:19 | 28.01.2022 15:50 |
26.01.2022 00:41 | 26.01.2022 01:05 |
25.01.2022 22:47 | 25.01.2022 23:15 |
25.01.2022 14:50 | 25.01.2022 14:50 |
25.01.2022 08:26 | 25.01.2022 08:15 |
22.01.2022 01:49 | 22.01.2022 02:00 |
21.01.2022 19:53 | 21.01.2022 19:30 |
21.01.2022 16:26 | 21.01.2022 16:45 |
21.01.2022 14:48 | 21.01.2022 15:16 |
21.01.2022 13:21 | 21.01.2022 13:50 |
21.01.2022 10:42 | 21.01.2022 10:25 |
21.01.2022 00:18 | 21.01.2022 00:20 |
02.12.2021 01:22 | 02.12.2021 01:20 |
01.12.2021 23:47 | 01.12.2021 23:55 |
01.12.2021 22:16 | 01.12.2021 22:15 |
01.12.2021 01:13 | 01.12.2021 01:30 |
30.11.2021 20:41 | 30.11.2021 20:30 |
26.11.2021 23:32 | 26.11.2021 23:55 |
26.11.2021 01:40 | 26.11.2021 01:15 |
25.11.2021 23:56 | 25.11.2021 23:30 |
25.11.2021 03:18 | 25.11.2021 03:40 |
23.11.2021 12:00 | 23.11.2021 12:30 |
23.11.2021 09:41 | 23.11.2021 09:15 |
23.11.2021 07:17 | 23.11.2021 07:05 |
19.11.2021 12:33 | 19.11.2021 13:00 |
19.11.2021 10:36 | 19.11.2021 11:00 |
18.11.2021 09:17 | 18.11.2021 09:30 |
16.11.2021 21:34 | 16.11.2021 22:00 |
12.11.2021 13:18 | 12.11.2021 13:00 |
11.11.2021 17:10 | 11.11.2021 17:15 |
11.11.2021 14:22 | 11.11.2021 14:00 |
And i want to have a table in my report which show as a result look like this:
and when i filter my WZNummer with a slicer my table should automatic filter with it
WZNummer | Order Label | Datum & Uhrzeit |
32568266 | 45727039 | 29.01.2022 01:45 |
32568266 | 45727039 | 28.01.2022 19:40 |
32568266 | 45727039 | 28.01.2022 17:40 |
32568266 | 45737574 | 28.01.2022 15:50 |
32568266 | 45737574 | 26.01.2022 01:05 |
32568266 | 45737574 | 25.01.2022 23:15 |
32568261 | 45747188 | 25.01.2022 14:50 |
32568261 | 45747188 | 25.01.2022 08:15 |
32568266 | 45727042 | 22.01.2022 02:00 |
32568266 | 45737574 | 21.01.2022 19:30 |
32568222 | 45737576 | 21.01.2022 16:45 |
32568222 | 45737576 | 21.01.2022 15:16 |
32568222 | 45737577 | 21.01.2022 13:50 |
32568222 | 45737579 | 21.01.2022 10:25 |
32568261 | 45737580 | 21.01.2022 00:20 |
32568261 | 45737580 | 02.12.2021 01:20 |
32568261 | 45737580 | 01.12.2021 23:55 |
32568266 | 45727039 | 01.12.2021 22:15 |
32568266 | 45727039 | 01.12.2021 01:30 |
32568266 | 45727039 | 30.11.2021 20:30 |
32568266 | 45737574 | 26.11.2021 23:55 |
32568266 | 45737574 | 26.11.2021 01:15 |
32568266 | 45737574 | 25.11.2021 23:30 |
32568261 | 45747188 | 25.11.2021 03:40 |
32568261 | 45747188 | 23.11.2021 12:30 |
32568266 | 45727042 | 23.11.2021 09:15 |
32568266 | 45737574 | 23.11.2021 07:05 |
32568222 | 45737576 | 19.11.2021 13:00 |
32568222 | 45737576 | 19.11.2021 11:00 |
32568222 | 45737577 | 18.11.2021 09:30 |
32568222 | 45737579 | 16.11.2021 22:00 |
32568261 | 45737580 | 12.11.2021 13:00 |
32568261 | 45737580 | 11.11.2021 17:15 |
32568261 | 45737580 | 11.11.2021 14:00 |