Analytic Functions: Examples
•Rank
–Top 10
sales-reps in each region
•Moving Window
–Today’s stock price minus 200-day moving average
•Period-over-period
comparisons
–Percentage
growth of Jan-99 sales over
Jan-98
•Ratio-to-report
–January’s sales as a percentage of the entire year’s