I am missing something small, I can feel it .
I found this on the forum - and it got me to a 90% solution:
Single Category Headers in workflow
My Solution:
<<Start: ORDERBY(FILTER("Next Day Scheduled Trips", ([_ROWNUMBER] = MIN(SELECT(Next Day Scheduled Trips[_ROWNUMBER], ([_THISROW-1].[dvrcallsign] = [dvrcallsign]))))), [dvrcallsign])>>
<<Start: FILTER("Next Day Scheduled Trips", ([_THISROW-1].[dvrcallsign] = [dvrcallsign]))>>
<<if:[tripid]=INDEX(orderby(Next Day Scheduled Trips[TRIPID], [dvrcallsign]),1)>>
<<[dvrcallsign]>>
<<endif>>
DATE: <<[DATE]>>
TIME: <<[TIME]>>
VEHICLE: <<[VEHICLE]>>
DVRCALLSIGN: <<[DVRCALLSIGN]>>
PUTIME: <<[PUTIME]>>
DOTIME: <<[DOTIME]>>
PUADDRESS: <<[PUADDRESS]>>
DOADDRESS: <<[DOADDRESS]>>
<<End>>
<<END>>
The result:
What did I miss to make the โnextโ driver have its own header?
The problem is your template if statement.
Iโd suggest something like
<<IF: [_THISROW] = MINROW( table, "_RowNumber" , [callsign]=[callsign]>>
That did not give me any errors, just reversed my missing header issue
<<Start: ORDERBY(FILTER("Next Day Scheduled Trips", ([_ROWNUMBER] = MIN(SELECT(Next Day Scheduled Trips[_ROWNUMBER], ([_THISROW-1].[dvrcallsign] = [dvrcallsign]))))), [dvrcallsign])>>
<<Start: FILTER("Next Day Scheduled Trips", ([_THISROW-1].[dvrcallsign] = [dvrcallsign]))>>
<<if:[tripid] = minrow(Next Day Scheduled Trips, โ_rownumberโ, [dvrcallsign] = [dvrcallsign])>>
<<[dvrcallsign]>>
<<endif>>
DATE: <<[DATE]>> TIME: <<[TIME]>> DVRCALLSIGN: <<[DVRCALLSIGN]>> PUADDRESS: <<[PUADDRESS]>> PUTIME: <<[PUTIME]>> DOADDRESS: <<[DOADDRESS]>> DOTIME: <<[DOTIME]>>
<<End>>
<<END>>
BUTโฆ Now I get the header over every rowโฆ
Thought that would have worked. I canโt get into this any deeper right now. But you should notice that there are 7 other threads linked to that thread of mine that you linked, I suggest you do more research. I know @Aleksi had posted somewhere another good method for this.
Awesome. I will
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |