Show only top 10 results

[generh6957]

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. 

[rockytopmark]

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.