Page filters in Cross-Tabs

How to apply page filters on different dimensions in a Cross-Tab

Page dimension filters can be used as a pivot filter in the cross-tab providing filtering on any dimension available in the dataset. You can have multiple dimensions in page dimension filter. 

Example 1 :

The below Sales cross-tab shows Product Category wise Gross sales over different years.

Lets filter the data based on Product Category and Year.

SALES CROSS-TAB BEFORE APPLYING THE FILTER

Step 1

In the Cross-tab Toolbar, click Outliner. The system displays the Outliner dialog box.

Step 2

Drag and drop Product Category and Year dimensions from the Dataset columns to the Page section. Click OK.

Step 3

The sales cross-tab will be displayed with Page dimension filters on the top.

To apply page filters, you can open the page filter and it will load the values and you can select the checkbox given beside the value and click on the green tick besides Page filter name as shown in the screenshot below. Here, I have selected Alcoholic Drinks and Bakery Product Category.

SELECTED VALUES  

Step 4

Similarly, select Year as ' 2014' and '2013' and click OK.

SALES CROSS-TAB AFTER APPLYING FILTER

Example 2:

The below example shows how to filter the cross-tab with Category names that contains 'Drinks'.

Step 1

Follow the procedure of Page Dimension Filter

Step 2

Beside the Product Category text box, click the Setting icon.

The system displays two icons: Delete (to remove the page filter values) and Advanced.

Step 3

Click the Advanced icon.

The system displays the Advanced filter dialog box based on column data type. In this case, it will show filter dialog box for string data type.

Note : You can provide one or multiple filter conditions using Advanced filter. 

Step 3

Select from options such as =,!= (not equal to),starts with, contains, etc.

Step 4

You can include multiple conditions by clicking ADD.

Example 3:

Let’s see how to filter the cross-tab data based on the Sales Date column. To show the data of April 2014, follow the below steps.

Step 1

Follow the procedure of Page Dimension Filter

The system displays the Time Series dialog box if the data type of page filter column is date.

Step 2

Select time series elements from Absolute, Relative, and Range time series tabs.

Step 3

In the Absolute tab, select Year as '2014' and Month as 'Apr'.

Click OK to apply the filter.

CROSS-TAB AFTER APPLYING THE FILTER

Example 4:

Options for page dimension filtering allow you to add filters on dimensions which are not present in the Cross-Tab. For example, to display the category sales of 'Washington' state for the years 2013 and 2014, follow the below steps.

Step 1

Follow the Procedure of Page Dimension Filter. Drag and drop 'State' and 'Year' to the Page section in the Outliner while creating the cross-tab and click OK.

Step 2

Select the filter values as below.

For the dimension - State = 'Washington' 

For the dimension - Year = 2013 and 2014

The result will be displayed as below.

SALES CROSS-TAB AFTER APPLYING THE FILTER