Hi Deepak - Thank you for posting a reply. I really appreciate it!
Your solution still determines the order sequence using a table calculation. I'm looking for a calculated field without any table calculation.
In a sheet, I just want to calculate the total YTD revenue. I don't want to display user id, order date, order id or any other details. Similarly, I want to calculate other KPIs in different sheets (For e.g., total number of customers in one sheet, Average Order Value in another sheet etc.)
I'm looking for a calculated field for order sequence that I can drag into into the filter pane in all the sheets where I have my KPIs so that I can filter for just the value 1. This way I will be able to calculate KPIs for first orders / new customers or repeat customers (Filter value >1)
You can use INDEX() and restart it for each user id.
Index() is also a table calculation which will not work for what I'm trying to do.