Using the Options Menu

Select to display a Pivot Grid view that presents the chart data in a full-page modal. You can select to slice and dice the data in the grid by dragging the facet dimensions from the left panel to the grid columns and rows. In addition, you can change prompts and facet values to analyze the data. When you click the Apply button in the top right of the modal, the chart is refreshed based on the current layout of the grid. Otherwise, when you click the Cancel button in the top left of the modal, it is closed and the chart layout is not changed.

Select to display the Update Filters dialog box, which enables you to add or remove filters for a model. The dimensions that are configured with blank values for Chart Axiscolumn in Step 4: Specify Data Model Options page of the Pivot Grid Wizard will be available to add as additional filters in addition to the default filter dimensions. SeeView Options.

By default, the Update Filters option is available for all Pivot Grid models in Fluid Viewer, but you can hide this option for a model. To hide it, use the Display Options section in the Step 4: Specify Data Model Options page.

See, Display Options.

Select to open the Chart Options dialog box, which enables you to change the chart layout, chart axis, filters, and so on. See Using the User Charting Options

Select to export the underlying PSQuery data to Microsoft Excel.

Select to save your personalization.

Select to open the Save As dialog box, which enables you to copy the current Pivot Grid model and save it as a different one.

• For all Simplified Analytic models, the unique name of each model is populated, and you are not required to enter the new model name.

• If personalizations are defined for the current Pivot Grid model, then personalization are also copied and included in the new model.

Select to open the Sort Options dialog box. See Sorting from Options Menu.