Creating the calculations

1. Click the down arrow next to Dimensions in the data pane and select Create Parameter.
2. In the Create Parameter dialog, do the following and click OK:
   • Name the parameter. In this example it is called "INPUT".
   • Choose Float for Data Type.
3. Right-click [INPUT] in the data pane and select Show Parameter Control.
4. Select Analysis > Create Calculated Field.
5. In the Calculated Field dialog box that opens, do the following, and then click OK:
   • Name the calculated field. In this example, the calculated field is named "PREV".
   • In the formula field, create a calculation similar to the following:     

   {MAX({FIXED State: (IIF(SUM([Sales])<[INPUT],SUM([Sales]),NULL))})}

6. Create a calculated field and name it for example "NEXT" with a calculation similar to the following:

   {MIN({FIXED State: (IIF(SUM([Sales])>=[INPUT],SUM([Sales]),NULL))})}

7. Create a calculated field with a name such as "Rank Percentile" with a calculation similar to the following:

   RANK_PERCENTILE(SUM([Sales]))

8. Create a calculated field with a name like "PREV%" with a calculation similar to the following:

   LOOKUP([Rank Percentile],-1)

9. Create a calculated field "NEXT%" with a calculation similar to the following:

   [Rank Percentile]

10. Create a calculated field and name lit for example  "PERCENTRANK" with a calculation similar to the following:

Building the view:

1. Drag [State] from the Dimensions Pane to the Detail Shelf on the Marks Card.

2. Right-click on [State] on the Marks Card and select Sort.

3. In the Sort dialog, do the following and click OK:

   • For Sort Order, select "Ascending".
   • For Sort By, select "Field", Sales, and Sum.

4. Drag [PERCENTRANK] from the Measures Pane to the Text Shelf on the Marks Card.

5. Right-click on [PERCENTRANK] on the Marks Card and select Compute Using > State.