TM1 Function for Excel, TM1RPTFILTER
TM1RPTFILTER is used to apply a filter to the Dynamic Report to sort the row based on a column.
Where can the TM1RPTFILTER function be used?
Excel
What is the TM1RPTFILTER function?
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).
What is the syntax for TM1RPTFILTER?
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)
A demonstration on how to use TM1RPTFILTER
In a Dynamic Report, sort the values in descending order for Q1 from the Quarter dimension.