2 Replies Latest reply on Sep 26, 2016 5:35 PM by Ana Yin

    Multiple Layout Containers help (+6 sheets)

    Ana Yin

      Hi everyone,


      I have 8 sheets to show on a dashboard (controlled by 'Select Period Display' parameter) - pls refer to workbook attached.


      When I select 'Months', I'd like both 'Sales-Month', 'Sales- FY'  and 'Profit-Month', 'Profit - FY' worksheets occupy the entire workbook (see "Ideal display 1" tab).


      When I select ' Periodic', I'd like 'Sales - QTR', 'Sales - HY', 'Sales - FY' and 'Profit - QTR', 'Profit - HY' and 'Profit - FY'  worksheets to occupy the entire workbook (see "Ideal display 2" tab).


      But right I don't know how to arrange the layout containers in such way that the worksheets occupy the entire canvas depending on the selection (refer to "Dashboard 1" - see how everything is squashed together).


      A client was adamant this must be the display so I've used Superstore as a mockup.


      If anyone can assist I'd really appreciate it!