Dynamically Display Your Top Five Reps with Windowing

Windowing functions perform calculations over a dynamic range.

Use windowing to create a chart that dynamically displays your top-five reps for each country. The chart updates continuously as opportunities are won. The example uses windowing to calculate:

• Percentage contribution that each rep made to the total amount, partitioned by country
• Ranking of the rep’s contribution, partitioned by country

These calculations let us display the top-five reps in each country.

The resulting graph shows the top-five reps in each country and displays each rep’s ranking.