Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are trying to create a column in a chart that will assign a number to each order in a chart.
There may be multiple lines on each order. Goal would be to start with 1 for first order. This Order may have 1,2,.....20 lines.
When the next order is shown in report, column will display 2. This will continue for all orders in the chart.
The orders are sorted by Order, then Order Line No.
I have tried to accomplish this a number of ways but come up empty. Thanks in advance for any suggestions.
Sound like you need to use RANK(), e.g.
RANK(TOTAL Order, 1, 1)
Did you try AutoNumber in the Script?
Can you show some sample and expected output?
