Worksheet Controls: An Overview
Summary of Content
- You must be a Sigma Creator or Admin to create and manage worksheet controls. Learn more.
- Worksheet Parameters and Totals are visible to Viewers; filters are not.
The Control Panel
Sigma worksheet controls live in the worksheet control panel, positioned directly to the left of the worksheet table and chart area. This positioning allows you to create and modify your control values while simultaneously watching your data respond in real time.
Opening, Closing, and Resizing the Panel
To open the control panel, click on the CONTROLS bar on the left side of the worksheet or the ‘Show Controls’ button in the toolbar.
The control panel can be resized and closed by dragging the blue hover bar on its right side.
Control Panel Content
Totals are single value column aggregates that live at the top most level or your worksheet. Calculated worksheet totals can be viewed and selected under the control panel’s TOTALS section. The TOTALS section is only visible if one or more totals exist in the worksheet.
Learn about worksheet totals.
Filters allow you to limit your data to show only rows that meet certain criteria. Worksheet filters can be created and managed under the control panel’s FILTERS section.
Learn about worksheet filters.
A parameter is a customizable field that can be added to a worksheet and referenced in formulas. Parameters can be huge assets for What-If Analysis and User Input Analysis. Worksheet parameters can be created and managed under the control panel’s PARAMETERS section.
Learn about worksheet parameters.