Previously, once you closed the results of your comparison, your analysis was gone. Now, a Last Analysis button retrieves the results. This is preserved even if you close the Total Access Detective add-in and return (provided your database remains the same).
Ranking functions include cumulative distributions, percent rank, and N-tiles. Moving window calculations allow you to find moving and cumulative aggregations, such as sums and averages. Lag/lead analysis enables direct inter-row references so you can calculate period-to-period changes. First/last analysis enables you to find the first or last value in an ordered group.