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.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book
