My report gathers customer sales data for the past year and the current year to show sales RANK (get it??). I have a column for previous year totals and one for current sales grouped by customer as well as a column for %age of total for each period. Sorting by TopN is a no brainer BUT what i'd like to do is have a column for each period that shows the customer rank for that period. This rank should (?) be based on a constant (like total sales for the period) and wouldn't change no matter what the sort is. Therefore, if TopN sorted YTD, the rank for both YTD and previous year would display the correct customer rank for each period (which, in my case, would usually be different per period). This is where i get to be a no brainer!! Any suggestions?