KB31914: How to apply rank metric to specific attribute elements rows on the report in Microstrategy Develper 9.4.x-10.x?

Users have requirement of applying rank metric to specific attribute elements rows instead of all rows of report. For example, a report with attribute "Quarter" and metric "Revenue".
Follow the steps below to rank rows in regarding to "Quarter" elements "2004 Q1","2005 Q1" and "2006 Q1" in Strategy Tutorial project: 

•  Create a "Quarter" filter with "Quarter" elements "2004 Q1", "2005 Q1" and "2006 Q1", as shown below:
  

•  Create a "Rank Test" metric with formula "Rank(Sum(Revenu){~})" and add "Quarter" filter as Condition of this metric, as shown below:
  

•  Create a report with attribute "Quarter", metric "Revenue" and "Rank Test".
•  Set "Join Type" to "Join 92" in menu: Data -> VLDB Properties -> Joins -> Join Type, as shown below:     

 
Note:
This step is only for users who use Access Database Warehouse to activate outer join type. 

• Set "Join Type" to "Outer Join" for metric "Revenue" in menu:  Data -> Report Data Options -> Calculations -> Metric Join Type, as shown below:
  

• Run the report, metric "Rank Test" only ranks rows in regarding to "Quarter" elements "2004 Q1", "2005 Q1" and "2006 Q1", as shown below: