MDX TopPercent Function

The MDX TopPercent function will sort the given data in the descending order. Then selects the required number of records from the sorted data whose total is greater than or equal to the specified Percentage. MDX TopPercent Function Syntax The basic syntax of the MDX TopPercent in Multidimensional Expression is as shown below: TOPPERCENT (Set_Expression, … Read more