Originally Posted by

**kotum45** Hi,

I have a set of data that belong to a company revenue generated through many different products.

In total 2000 producst.

So the data is like this

__Product__ __Revenue__

Product 1 $2000

The list goes on to Product 2000 and revenue varies.

The question is to determine which products to promote. There is no set budget.

So based on revenue the question asks to suggest which products to promote. (Company principle is to promote higher revenue making products) but how do you determine the most optimum point.

I sorted all valued from high to low and created a chart. Then added a linear trend line.

And I was going to take the intercepting point as the optimum point?

Any ideas please?