2 Replies Latest reply on Feb 11, 2016 1:46 AM by Arshad Malik

    Pyramid - Customer Classification - Pareto

    Jean-Pierre Bakhache

      Dear community,

       

      I need some help into achieving a pyramid-like view (picture attached).

      The purpose is to classify the customers based on their revenues into 4 categories (platinum, gold, silver, bronze).

      The calculated field "Pyramid" will show how the classification is done.

      The output should be a pyramid (or a bar chart to simplify) showing the 4 categories, the related contribution to the revenues and the number of customers that fall into this category.

      Based on the sample, platinum is up to 24.42% with 34 customers, gold is up to 54.86% (or 30.44% for this category) with 102 customers, etc...

       

      Appreciate your help.