Filters - SuperWEB2

Filters (or subjects in SuperCROSS) are an extra dimension that you can add to a table. When you apply filters to a table then only records that match the filters will be included in the results.

For example:

The following table shows Occupation by State with no filters applied:

The following version of the table has two filters added. With the addition of the filters, the values in the table will now only count individuals who are both Male and Married:

As shown here, you can add multiple filters to a table, and only records matching all of the filters will be included in the table. However, you can only add one field item from any given field (for example you cannot add Gender - Male and Gender - Female at the same time).

You may also have a summation in the table, but if you do, you may only have one summation total.

Filters and the Default Summation

The addition of this feature has slightly changed the way SuperWEB2 applies the default summation to the table.

In previous versions, if you started to create a table without adding a summation option then SuperWEB2 automatically applied the default summation to the inverse axis (i.e. row if you added to column, column if you added to row).

Now, the default summation is automatically added to the table and shown under the filters:

If you add a summation option to any dimension then the default summation will disappear and no longer be used.

Add a Filter to the Table

To apply a filter:

1. Select a single field item from the tree and click Add to Filter.
   

   

2. SuperWEB2 adds the filter to the list above the table.
   

   

3. You can now add additional field items to the filter if necessary.

   

   You can add multiple field items to the filter but you must add them one at a time. You can only add one field item from any given field.

Remove a Filter

To remove a filter, click [ X ] next to the filter name: