4 Replies Latest reply on Feb 11, 2016 1:20 PM by Brian Scelzo

    Trying to Dynamically Sum Top Ten Clients for Percentage of Total Revenue Chart

    Brian Scelzo

      I'm working on an item to show what percentage of the total revenue earned in a period could be attributed to the top ten clients.  I want to be able to show the top ten clients in a variety of different cuts and they should hopefully update dynamically.  For example I'd like to be able to show the top ten revenue as a percentage of total revenue for a given month, a given geographic area, a given region and account manager.

       

      Is there a way to sum up the top ten so that I can divide it by a TOTAL(Sum(Revenue)) table calculation?  I've attached a sample workbook along with the ranking formula I've been using up until this point.  I'll be happy to try to explain further.

       

      Thanks,

      Brian