Example - Use Custom Rank

You can override the default rank behavior.

In this topic, you analyze the relative performance of order methods. You want to know the answers to these questions:

• What is the rank of the order methods shown in the crosstab?

• What is the rank of the order methods in relation to all order methods?

If you need more help, see Exclude Items and Use Custom Ranking.

Steps

1. Create a new analysis using the Sales and Marketing (cube) package.

2. Add the following items to the crosstab:

   • Revenue as the default measure

   • Order Method as the rows

   • 2004, 2005, and 2006 (in Time) in the columns

3. Exclude Telephone and Fax.

4. Select Total and rank by right-clicking.

   Analysis Studio ranks the items. Is the rank the same if you include all items?

5. Right click the ranked column and click Edit this Calculation.

6. In the Calculate dialog box, under Rank, click Custom.

7. Under Rank within the following, click All items, then click OK.

8. In the Calculate dialog box, under Name, type

   Rank, then click OK.

   Your analysis will look like this.