I have a module view where it has time as a dimension (I'm able to select which period it displays) but would also like to display the annual result next to it. For example, if I was showing Aug 2019 sales, directly to the right, in the same view, I would see the 2019 annual results. Below is a screenshot of what I have currently, the issue is that when they scroll in one, it does not scroll in the other, so they cannot compare selected month results to the entire year's results.
A possible solution which will allow you to maintain the tow grids is to synchronise the line items. Allow the user to browse from left to right in the left hand grid and if they required the YTD, FY19 or any time period they can select that column and the right hand grid will sych as appropriately. Firstly, re-pivot your right hand grid to place line items as a page selector and time period as columns. Use the show functionality to select the required time period aggregation; FY 19 and / or YTD. Ensure that line times are synchronised in the right hand grid and when the user selects a line item in the left grid the right grid should change accordingly.
Chris Heathcote Bedford Consulting
Gold Partner and Regional Partner of the Year 2021, EMEA