0 Replies Latest reply: Jun 4, 2013 9:54 PM by Amirali Vastani RSS

    80/20 without Pareto

    Amirali Vastani

      is it possible to do a Count(Customers) from Total Customers in a cycle group that make up 80% of the sales for each of the value's in the group?

       

      For instance,

       

      1. cycle group for Region, Office, Employee

      2. get a count of customers depending on the current field

      3. get a count of customers depending on the current field that make up 80% of the sales, for eg. Region - NorthAmerica has 5 offices and 20 employees. We want to know how many customers in Region - North America, Region - Europe make up 80% of sales, then user can change cycle and expression should be able to compute the count of customer for each value in the next grouping.

       

      This is not Dimension Limits because it is not 80% based on the values displayed for the current field, but rather dimension limits for each field value of the current field