Then do the following in the Filter dialog box: Open a sheet you plan to add to your dashboard, and drag the new calculation to the Filters shelf. In the formula text box, enter the name of the parameter you created above. Give the calculation a descriptive name like Display sheet. On any sheet, right-click an empty area of the Data pane at left, and select Create Calculated Field. Under List of values, type All for the first value, and then add values with the name of each view in the dashboard. In the Create Parameter dialog box, do the following:Įnter a name that will appear appear above the menu, like Select a View. On an individual worksheet, right-click an empty area of the Data pane at left, and select Create Parameter. To leave a dashboard and open a completely different sheet, use Navigation objects. This is a much simpler approach, though each button will reveal a separate object. Tip: To show sheets using separate buttons rather than a single menu, instead use Show/Hide buttons. Using a combination of a parameter and a calculated field, you can create a drop-down menu that lets users select an individual view that automatically expands to fill a dashboard.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |