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?
I ended up solving this. The issue was I had my date set to continuous and when I set it to discrete I was able to apply the index function to create a rank.