I would like to show the following information on the same screen in tables or graphs in Board:
The upper table show total headcount by Company for the last two years by quarter. This table should stay like that and not be adjusted by a selection of the screen/entity.
The lower part should show the headcount by division of each company with a dynamic filter, based on the Quarter (entity) selection of the user.
I tried to use a layout selection in the upper table, but this is overwritten by the selection in the layout.
Any advice? Is this even possible on the same screen or do I need to create multiple?