Has anyone successfully made a concentration curve in Report Studio?
I have a list that has a rank of 1-100 in one column, and a 2nd column that has a running total of amount X (let's call it sales). So:
1 100
2 110
3 125
4 135
5 145
x y
100 1,456
I want to plot that info as a curve, so the x axis would be 1 through 100, the Y axis would be sales, and my plotted points would be a curve that goes up and to the right.
I can't get it working - anyone ever tried this?