Ordering a report based on the selected measure in a descending order.

Setting a number below or above which activity will not be reported. For example, reporting only brands that spent more than $100,000 and less than $1,000,000. You must rank in order to cutoff within reports.

Go to STEP 2: LAYOUT within the Explore custom report setup process.

Select the SORTS needed for your report (left side).

The selected sorts will appear in the Selected SORTS and MEASURES column (right side).

**PLEASE NOTE: The option to Rank will only appear if two or fewer sorts are selected. DO NOT include more than two sorts if you would like to apply a rank.**

Select the measure needed in the MEASURES column (middle).

The selected measure will appear in the Selected SORTS and MEASURES column (right side).

Click on the Ranking Icon next to the selected measure.

The option to apply a rank/cutoff will appear.

Select Level of Detail to Rank

Base the rank on the TOTAL column or any other column selected as the column type.

The example below shows ranking based on the Time Period column selection in STEP 2: LAYOUT, with a monthly breakout selected in STEP 5: TIME PERIODS.

The rank can be applied to the measure selected or to a calculation which has been applied in STEP 2: LAYOUT

Rank numbers can also be included.

Check the Include Cutoff box.

Specify the cutoff criteria, whether you are including a maximum cutoff, a minimum cutoff, or both.

Click Apply at the bottom.

A blue dot will appear next to the Ranking Icon indicating that Ranking/Cutoff options have been included.

If you have any additional questions, you can reach out to your local Vivvix Client Success Manager. Our support team is also available for assistance via email at support@vivvix.com.