Applying Data Filters to a DimCount Column

You can add data filters to a column to display more meaningful data. For example, if you are using a Sales Income DimCounts column, you could specify that the column shows the DimCounts for a particular region, or DimCounts for income above a specified threshold.

You can add data filters as arguments to the DimCount Column definition in the Add/Edit Column Closeddialog box.

Syntax: dimcount [ <Dimension_name>, <Filter - Dive>, <Filter - Dive> ...]

Where: <Filter - Dive> is defined in one of these ways:

<Dimension_name = Dimension_value> — For example, Sales Team = Team Alpha

<Summary_column_definition comparison_symbol n> — For example, Total Units >= 1000

 

NOTE: With the model engine, you cannot use a dimcount expression as a predicate inside a filtered dimcount expression. For example, dimcount [Customer, dimcount [Order Date] > 1, Total [Units] >17] returns an error.

Add or Edit column dialog box showing the definition of a sample dimcount column.

In this example, a Salesperson DimCount column with a data filter specifying one of the Suppliers (Holly Springs Farm) has been added to the tabular display.

Sample tabular page using filters in a dimcount column.

The Console shows that A&P Produce/Baltimore purchsed 43 types of commodities, and the HSF dimcount column shows that 6 of the 43 commodities were supplied by Holly Springs Farm.

NOTE: A comparison type of data filter can have only one dimension value. If you want to filter on a range of values, for example:

1000 < Total[Units] <= 2000

you can define a calculated field, such as:

InRange = AND(Total[Units] > 1000,Total[Units]<= 2000)

and use that field as the filter:

dimcount[Order Date,InRange > 0]