Thanks for the reply, i tried Index function as well, but i am unable to sort it either ascending or descending as well as i need to use it for further calculations and since i am connecting to SQL server and i have a lot of Serial Numbers, manual sorting is not at all possible. So i want to create a calculated filed which can do the same task as index.
Kindly let me know if thats possible.
Thanks & Regards,
I don't know how you actual data looks like, solution given based on the sample data which you have attached with you post. And solution given worked as per the expected output.
At the very beginning you should post the sample mock up based on the actual data structure. Provide some sample which matches with your original data set and also explain a bit your exact output with some example then any one of us will take a look and try to provide solution.
Like this ?
I created calculated field Running Count:
IF ATTR([Serial Number])=LOOKUP(ATTR([Serial Number]),-1) THEN
Running Count.twbx 23.4 KB
Yes, this is what i was looking for. Thank you so much.
Mahfooj Khan - thanks for your reply and time, but i have marked Ombir's answer as Answered because i wanted to create a calculated field and note to use index. Still thanks again.
I have another follow - up question, if possible kindly help me in answering that too. below is the link;