1 Reply Latest reply on Jun 28, 2016 8:09 AM by Scott Abboud

    Maintain top 10 ranking on whole year while showing historical trend per month

    Scott Abboud

      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?

       

      Thanks, Scott