Hoping someone can help me. I have a view that is pulling rates by customer. Each customer will have multiple records. I want to assign a row number for each rate record per customer. So, customer ABC having 3 rates will show results with numbers 1,2,3. Customer DEF having 6 rates will show results numbered 1,2,3,4,5,6... and so on. I know how to do an ACCUM function, but it accumulates across ALL records, tried grouping but it didn't change my results.
Is there a way to make this work?