I am using a rank table calculation to filter the top ten customers (by sales) that use a particular part number for a rolling 12 month period. My next step is to simply show their sales trend per month over the rolling 12 month period; however when I break out the sales by month to show the trend I lose the ranking based on total sales for the rolling 12 months.

Is it possible to keep the ranking of total sales for the rolling 12 months while showing a historical trend per month?