Forum Discussion
Add sequence number that resets when filters applied
- 2 years ago
Decided to take the easy path and used a paginated report and added a column with =RowNumber("Contracts")
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
Decided to take the easy path and used a paginated report and added a column with =RowNumber("Contracts")