Filter Products that gets 50% of turnover

system · February 12, 2003, 5:45am

Hi all,

I have a table like,


-----------------------
Product    |    Sales    |
-----------------------
Produc1    |    1234    |
Produc2    |    234      |
Produc3    |    456      |
Produc4    |    2345    |
........
ProducN    |    232      |
-----------------------
Sum            34,500
-----------------------

We want to apply a filter so that we should get only the Top N products (based on sales) which got us 50% of total Sales. How should I do this??

Thanks & Regards,
C.P.Mohanraj
FCITS, India.

cpmohanraj (BOB member since 2002-09-23)

system · February 12, 2003, 6:33am

I think you need to do percentiles. Do a search on the forum for percentile. I believe there was a topic on this earlier this week.

Steve Krandel (BOB member since 2002-06-25)

system · February 12, 2003, 6:50am

I tried searching for it. I don’t find anything relevant to my situation. COuld you please help me in this??

cpmohanraj (BOB member since 2002-09-23)

system · February 12, 2003, 1:52pm

I’m not sure you can do exactly what you want, since you won’t be able filter the data based so that only those that contribute to the top 50% are visible.

Steve Krandel (BOB member since 2002-06-25)

system · February 13, 2003, 3:10am

Check this link. Not a elegant way but it still works with Alerters.

Sri

Sridharan (BOB member since 2002-11-08)