Creating Percentiles/Deciles

• daveangel

  SSC Enthusiast

  Points: 116

  More actions

  October 6, 2005 at 4:18 am

  #91408

  Hi Folks,

  I am looking to split a table into percentiles based on a numerical field i.e. Profit.

  For each of the percentiles I am looking to do some simple calculation i.e. Average Profit, Average Age etc.

  Is there any easy way I can do this where I can decide on whether I want percentiles (split into 100 groups) or deciles (split into 10 groups).

  Can anyone help?

   

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  October 6, 2005 at 5:08 am

  #595398

  Examples, please.

  We need a tabledefinition and some sample data and the results you'd like.

  /Kenneth