4 Replies Latest reply on May 27, 2016 11:03 AM by Ron Ommerborn

    Ranking with Level of Detail calculations

    Ron Ommerborn

      The following view has an LOD calculation for total sales per customer across all months, which is being used to sort the customers.  The bar represents the percent of sales for a specific month for each category and customer.

       

      I'd like to filter this view by the top 35 customers based on their total sales (the LOD calculation).  Its just not working (due to table calculation issues).  The full scope of the problem and how I got there are explained in the captions on the sheets of the attached workbook.

       

      TheGoal.jpg

       

      Thanks everyone for your help.

      -Ron