Widget selections can be configured to filter all widgets on the sheet, as well as filter specific widgets only. These settings can be modified from the Widget Interconnectivty button in the Widget Toolbar:
When a Widget is set to "Affects Global Scope", selections made in it will filter all widgets set to "Affected by Global Scope".
Disabling the "Affected by Global Scope" option allows you to place widgets that are isolated from global selections. You can have these widgets filtered by selections in specific widgets by navigating to the "Available Widgets" menu and selecting the appropriate filtering widget.
|
When setting a widget to specifically filter another, the two widgets may be bound to data from different data sources. However, this is only true if the filtering widget is bound to dimensions that also exist in the data source the filtered widget is bound to. If you are unable to set a widget to filter another widget, this means one of the following:
- The data source for the filtered widget does not contain dimensions with the same name as those bound to the filtering widget. In this case, rename the dimensions in one of the data sources to match the names of those in the other.
- The dimensions do not contain the same type of data (numbers and text, for example). In order to be able to perform this the dimensions in both data sources must be of the same type.
- Widgets bound to OLAP data sources cannot only set to filter widgets that are bound to other OLAP data sources. The dimensions in this case must be identical, i.e derived from the same source field.
|