Add sequence number that resets when filters applied

[Jack2of3]

I need to add a Row Number (1,2,3,4...) to a table that resets to (1,2,3,4...) when a filter is applied.

This is what I entered: *note: "ROW_NUM" is selected via SQL.

[YukiK]

Could you elaborate on your ask? What do you mean by reset? Are you saying the row number should be per group? Also if you could share a sample data, that would be immensely helpful for us to troubleshoot.

[Jack2of3]

By Reset I mean the row numbering should reset to 1,2,3,4... if a filter is applied like Cost Center "2252". The resulting rows would then show 1,2,3,4.... There are numerous filters that could be applied. The row sequence is based on Contract IDV which is unique for each row.

DCOO Cabinet Name Dept. Name Dept. Number COST_CENTER_NAME COST_CENTER CONTRACT IDV
"STANLEY, EDNA R" TRANSIT SERVICE DELIVERY BUS TRANSIT OPERATIONS 3233 OPERATIONS CENTRAL INSTRUCTION 3201 PS91211000
"STANLEY, EDNA R" TRANSIT SERVICE DELIVERY BUS TRANSIT OPERATIONS 3233 OPERATIONS CENTRAL INSTRUCTION 3209 PS134942000
"STANLEY, EDNA R" TRANSIT SERVICE DELIVERY BUS TRANSIT OPERATIONS 3233 OPERATIONS CENTRAL INSTRUCTION 3209 PS4071300
"STANLEY, EDNA R" TRANSIT SERVICE DELIVERY BUS TRANSIT OPERATIONS 3233 OPERATIONS CENTRAL INSTRUCTION 3209 PS79597000
"STANLEY, EDNA R" TRANSIT SERVICE DELIVERY BUS TRANSIT OPERATIONS 3233 OPERATIONS CENTRAL INSTRUCTION 3209 PS81176000
"AMIRI, SHAHRZAD" SHARED MOBILITY CONGESTION REDUCTION 2003 EXPRESSLANES 2220 PS48720000
"AMIRI, SHAHRZAD" SHARED MOBILITY CONGESTION REDUCTION 2003 EXPRESSLANES 2220 PS94845000
"AMIRI, SHAHRZAD" SHARED MOBILITY CONGESTION REDUCTION 2003 EXPRESSLANES 2220 PS401642000
"AMIRI, SHAHRZAD" SHARED MOBILITY CONGESTION REDUCTION 2003 EXPRESSLANES 2220 PS51236002

[Jack2of3 · Accepted solution]

Decided to take the easy path and used a paginated report and added a column with =RowNumber("Contracts")