Re strart from 1 serial number of order item table

[sunil_prajapati]

One more help please…

i have two table "sales’ & “order item”. order item is reference to sales table.

sales have invoices and in invoices there is a related order item. and in order item there is sales invoice number column also available with any(select() formula.

i want to restart serial number of order item when sales table invoice number or order item column invoice no is new or changed and it will increase continue until invoice number is same. if invoice number is changed again it will be restart from 1

thanks
sunil