I need to create a custom column or calculated column to display auto increment number (like serial number) from the specific field name wise (group field wise) from the list. For example,
name type ABC merchant DEF employee GHI merchant JKL merchant
Then i want the result like,
name type SN ABC merchant 1 DEF employee 1 GHI merchant 2 JKL merchant 3 MNO employee 2 PQR customer 1
How can I achieve this from SharePoint or InfoPath Form? Any help would be appreciate.