I'm looking for some help on displaying data from one dataset across two tables.
I currently have a dataset that displays results in a table on my dashboard. The results can be anywhere from 1 to 50 rows worth of information. As this will be displayed on a TV in a production facility, I would like to show all potential values on one screen without the need to scroll (as the TV/PC will not have any input devices for the users) and my idea was to display the results across two visual tables.
The first table would show rows 1-25 of the results, and the second table would show rows 26-50. The image attached is how I would like the data to be shown (as you can see it displays the earliest "PickDate" value at the top of the first table as 02/08/18 and the earliest "PickDate" value at the top of the second table as 28/08/18, as the first table only shows up to the 27th at the bottom).
The values in the table will change as the source location is updated and lines are removed when they are no longer required, so in theory it needs to be a dynamic way of showing the data. For example, If there are only 30 rows available in the dataset I would like it to show 25 in the first table and then 5 in the second table.
I've been racking my brains but cannot seem to see how this would be possible.