2 Replies Latest reply on Jun 20, 2013 1:53 PM by John Crumpton

    How do I show the top 25 counties where the success rate for a product is greater than the total success rate for the product?

    John Crumpton

      Good morning.  I need to create a table listing the top 25 counties (FIPS) where the success rate for the selected product is greater than the total success rate for the product.

       

      In the attached workbook, the total success rate for Product ID 4 is 48.3% (it's shown in the grand total at the bottom).  I need to limit the output to the top 25 counties (ordered by SUCCESS units in descending order) where the counties' individual success rates are > 48.3%.  The result should look something like this:

      Untitled-1.jpg

      Finally, is it possible to hide the final % of Total column?

       

      The workbook I'm using is attached.

       

      Thanks!