2 Replies Latest reply: May 26, 2015 8:41 AM by Alexander Müller RSS

    Quantile calculation with non numeric first dimension

    Alexander Müller

      Hi all,

       

      I am trying to create a bar chart displaying the amounts of businesses in each city sorted by quantiles depending on their revenue (please see graph below).

      I am guessing the steps in the formula would be:

      Step 1: Rank the 100 companies in my sample by revenue (largest to smallest).

      Step 2: Define 4 quantiles (each consisting of 25 companies)

      Step 3: Count how often each city is represented in each quantile and end up with a bar chart (such as below)

       

      I assume there has to be a formula doing all that work but unfortunately I have not quite figured it out.

      I am very grateful for anyone helping me out!

       

      Thank you!

       

      Example.jpg