Impromptu User Help  7.5.0
Complex Reports > Crosstab Reports >

Filter Data in Crosstab Reports

You can filter data in a crosstab report by applying one or more of the following types of filters:

For information about detail and summary filters, see .

If you're familiar with SQL, you can think of a crosstab filter as having a predicate in the WHERE clause on the second SQL pass.

Crosstab filters are used with only crosstab reports. If you change the crosstab back to a list report, the crosstab filters are removed from the list report.

For Example

You create a crosstab report that displays the sales totals across the Great Outdoors line of products for all customers.

You apply the following four filters to the report.

You apply

That looks like this

The detail filter

(Product Line ='Alert Devices' and (Customer Type = 'Camping Chain' and Customer Name starts with 'F')) or (Product Line = 'Alert Devices' and (Customer Type = 'Sports Chain' and Customer Name starts with 'A'))

The summary filter

Total Sale Amount < 5000

The crosstab detail filter

Alert Devices Microwave Detective > 200

The crosstab summary filter

Total < 10000

The report now looks like this.

Steps

  1. Create the crosstab report.

  2. From the Report menu, click Query and then click the Filter tab.

  3. In the Filter Type box, select either the Crosstab Detail filter or the Crosstab Summary filter.

  4. Create a filter expression using the components in the Available Components box.

  5. Click OK.

Tip: To quickly apply a filter to a crosstab report, use the Filter button   on the toolbar. For example, if the cells in your crosstab report are values of Average Margin and you select a cell value of 25 and click the Filter button, the crosstab filter is Average Margin = 25.