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?
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |