Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

New to CR, need help with a simple formula...

Status
Not open for further replies.

benlinkknilneb

Programmer
May 16, 2002
590
US
Hey all,

I've got a report that currently has a scatter plot on it like this:

X-Axis = Scrap
Y-Axis = Temperature

I'd like to take the two fields from the scatter plot and list them by frequency, like this:

Scrap Temperature Frequency
----- ----------- ---------
4.5 2150 6
4.5 2175 8
3.2 2150 4
3.2 2140 4
3.2 2180 2

In other words, if there are 6 entries on the scatter plot for the point (4.5, 2150), this list would show a line like the first one in the table.

I'd prefer it to be sorted by "Scrap" in descending order, but that's not necessary. I just don't know enough about CR to implement it. Can you give me a hand?

Ben
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top