Creating the number sequence

[glatocha]

Hi, 

I am plotting the products in production sequence in the order of production. 
Unfortunatelly my data, does not have a filed "position in sequence" but the production sequence is sorted by 
- order in sequence
- product in order

To have the bars sorted correctly I created a field Order*100+product.

Is there a way to create this as a normal numbers 1,2,3, ...

Here you can see:
order 1, products 1..3
order 2, products 1..3
...

[Mark_Little]

I would look to do this in script.

If you sort it in that order your could use PEEK or PREVIOUS function to create the numbering you like.

Mark

[marcus_sommer]

You may combine both information differently within a dual(), like:

dual(Order & ' - ' & product, Order*100+product) as orderProduct