Fernhill Supply sells wholesale in three regions, and its financial year starts in October. Build a window one part at a time and watch which rows each row's value is worked out from.
1. Build the window
Start from a preset, or set each part yourself.
2. Every row keeps its line
current rowrows used for it Pick a row with a click, or Tab to the table and use the Up and Down arrow keys.
3. The tie case: RANK vs ROW_NUMBER
In North, R04 and R05 both sold 60,000. Last quarter someone picked the top rep with ROW_NUMBER, and one of them was left off the bonus list.