| 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 |
||||||||||