Page filters in Cross-Tabs

Modified on Thu, 14 Mar at 1:10 PM

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.

image001.png

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.


 

image002.png

OUTLINER WITH PAGE DIMENSION FILTERS



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.

The sales cross-tab will be displayed with selected categories for the selected years as below.


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

In the value drop-down list, enter the value as 'Drinks' and click SAVE.

PAGE DIMENSION FILTER - ADVANCED

You can include multiple conditions by clicking ADD.

Click OK to apply the filter.

SALES CROSS-TAB SHOWS CATEGORIES THAT CONTAINS 'DRINKS'


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'.

image007.png

 
PAGE DIMENSION FILTER – TIMESERIES WINDOW

Click OK to apply the filter.


image008.png

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.

image009.png

SALES CROSS-TAB AFTER APPLYING THE FILTER


Note: This article is based on Smarten Version 5.X. This may or may not be relevant to the Smarten version you may be using.
page dimension filter Outliner filters page filters Advanced Filter Include exclude Absolute Relative Range Time Series

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article