TM1RPTFILTER

TM1RPTFILTER defines the filter applied to a Dynamic Report column dimension.

Syntax

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

Argument

Description

 Required/Optional

ReportView

A cell reference to a cell that contains a TM1RPTVIEW formula. The filter applies to the view specified by the TM1RPTVIEW formula.

 Required

Tuple

A tuple string specifying the member in the column dimension to which the filter applies. For example, [month].[Feb].

 Required

FilterFunction
One of the following filter function names:
  • TOPCOUNT
  • BOTTOMCOUNT
  • TOPPERCENT
  • BOTTOMPERCENT
  • TOPSUM
  • BOTTOMSUM
 Required

FilterValue

A filter value.

Required

SortOrder
One of the following sort orders:
  • asc: Ascending
  • desc: Descending
  • nbasc: Ascending without breaking the hierarchy
  • nbdesc: Descending without breaking the hierarchy
 Required

Example

TM1RPTFILTER($B$4,"[month].[Jan]","TOPCOUNT",5,"asc")