4 Replies Latest reply: Sep 20, 2012 5:11 AM by Lotfi Benkhider RSS

    Top 10 Customers by Total Tons per Week

      I am new to qlickview and have a simple request that seems to be more complicated than I would have thought.  I need to display the top 10 customers by week based on a metric of SUM(METRIC TONES)

       

       

      If I have The customer and the week in the dimensions and the follwoing formula in the expressions I get the correct ranking:

       

      Rank(SUM(METRIC_TONS))

       

      The issue is I only want to see the top 10 customers based on that ranking.  I have tried a few different versions of what I thought would be needed as a calculated dimension, but all my formulas just output //error calculateing formula.

       

      Not sure how to go about this, any direction would be wonderful.

       

      Jim