Use this dialog to create a band by rank calculation. A band by rank calculation creates several bands (for example, quartiles) and places each value into one of the bands according to its ranked list position. In other words, each band contains the same number of values. For example, if you have 1000 values you might want to create four bands (that is, quartiles), each containing 250 values.
Note: To analyze the distribution of values, you might want to use a band by value calculation instead (for more information, see "Band by Value dialog").
For more information, see:
"What are analytic functions?"
"How to create a calculation using an analytic function template"
Use this field to enter the number of bands into which you want to assign values. For example, type 4 to assign values into quartiles.
Use this drop down list to choose the item for which want to calculate the rank. For example, to calculate the relative position of sales outlets based on sales, you might choose Sales SUM.
Use the adjacent drop down list to specify the ranking order. For example, you might choose Highest Value Ranked 1 if you want sales outlets with the highest sales to be in band 1.
Use this drop down list to choose an item for which you want to calculate a secondary rank, which is used to determine the rank when two values have the same primary rank (that is, based on the item specified in the Rank based on field).
Use the adjacent drop down list to specify the ranking order. For example, you might choose Lowest Value Ranked 1 if you want sales outlets with the highest sales and the lowest costs to have the highest ranked list positions.
Restart banding at each change in
Use this list to specify which groups to use to arrange results into groups (sometimes referred to as partitions).
For example, if you want quartiles for each year, you might choose Calendar Year. In other words, if you have Sales SUM values spanning two years, you would have four bands for each year.
If you do not specify a group, Discoverer treats all worksheet values as a single group.
This read-only field displays the underlying formula that you are building as you specify values for the fields above. This formula is updated each time you change one of the values in the fields above. When you click OK, the formula is transferred to the Calculation field in the "New Calculation dialog" or the "Edit Calculation dialog".