Excel Functions

TM1 Function – TM1RPTFILTER

Available In

Excel

Definition

TM1RPTFILTER is used to apply a filter to the Dynamic report to sort the row based on a column.

Used for Dynamic Reports (Active Form).

Syntax

TM1RPTFILTER(TM1RptView, Tuple, FilterFunction, FilterValue, SortOrder)

TM1RptView = reference to the TM1RPTVIEW function from a Dynamic Report
Tuple = the column to filter
FilterFunction = one of these functions: TopCount, BottomCount, TopPercent, BottomPercent, TopSum, BottomSum or leave empty for all
FilterValue = a numerical value (OPTIONAL)
SortOrder = one of these orders: asc (ascending), desc (descending)

Example

Using this Dynamic Report, sort the values in descending order for Q1 from the Quarter dimension.

Show all format areas to find where TM1RPTVIEW is used.

Add TM1RPTFILTER to an empty cell and populate these parameters.

TM1RptView (SAFID) = the name ranged or it could have been B12
FilterTuple (SFilterTuple) = “[Quarter].[Q1]”
SortOrder (SSorting) = desc

Rows are now sorted in descending order.


Video Demo