I want to show only the top 10 dealers based upon a utilization %. I have the utilization % sorted in decending order, but cant get to only show top 10, tried inserting row numbers, but cant filter on that.
1). Create a new query calculation, call it "Rank_Util"
2). In the expression for Rank_Util
a). If the data is accessed via relational model, use the Rank() function on the Utilization%
b). If the data is accessed via PowerCube or Dimensionally Modeled Relational, use
TopCount() function
3). If Relational, create a summary filter: [Rank_Util] <= 10. There is no filter needed if you use TopCount with Dimensional.