Cubewise
ConsultingEducationSoftwareKnowledge HubSupportCompany
GB
    global-search

    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

    Which TM1 Server version is this function available for?

    Version 11 and 12

    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.