3 Replies Latest reply on Jul 21, 2016 7:13 AM by Jamie Morgan

    Equal quintile groups for multiple measures

    Jamie Morgan

      Hi,

       

      I am trying to create quintiles for multiple different metrics and different groups. I have created a sample of how I would like it to look using the EU superstore data. The data should be quintiled down each category for each city but grouped by country.

       

      The groups should be of equal size and if possible when there is not 5 unique results then to split it out from quintile 3.

       

      I know that this may not be strictly be the statistically correct way of quintiling but it is the way that my customers understand it.

       

      any help would be greatly appreciated.

       

      Jamie