count up function

[thanhphongle]

Hello community,

is there a function where I can count up the rows group by customer_ID ?

Example: See the expected solution in the last column (count up rows)

customerID	orderID	orderdate	quantity	selling_price	count_up_rows
1	1001	01.01.2019	2	200	1
1	1002	15.01.2019	3	300	2
1	1003	01.08.2019	1	100	3
2	1004	15.01.2019	1	10	1
2	1005	30.06.2019	1	20	2

Thank you for your help.

[Vegar · Accepted solution]

IF you have unique order ids then you can do this:

Autonumber(orderID, CustomerID) as count_up_rows

[thanhphongle]

it works ! Thank you so much!