PDF Grouping a part of the data [UPDATE]

[Hussein_Osseily]

Hello Everyone, 

I know PDF grouping has been discussed a lot, i just couldn't find something similar to this case.


Below is the template am using to generate a load list of every truck. 
This will generate a pdf of every truck reference.

The data in red is unique / same for every truck Ref

The data in green are different as it's the shipments / cargo details.

What i am trying to acheive here, is to generate one PDF file that will include all the lists that are trucked by the same trucking supplier (column name [Trucking by]) 
All data are in the same table "Unplanned Shipments"

Updated:

I added an outer Start select expression as below, it works but if the same Truck Reference has several Shipments its creating severals of the same reference . 

Any help would be appreciated.

[Suvrutt_Gurjar · Accepted solution]

---

@Hussein_Osseily wrote:

I added an outer Start select expression as below, it works but if the same Truck Reference has several Shipments its creating severals of the same reference . 

---

You may want to try below.

Please create a slice called something like "Minrow_Slice" with an expression something like 

[ID]=MINROW("LL", "_ROWNUMBER", [Trucking By]=[_THISROW].[Trucking By])

Then your outer START expression can be something like 

<<START: Minrow_Slice[ID] >>

[Hussein_Osseily]

Thanks sir, this helped a lot and it works in my case. 
Other workaround that i just figured:

Virtual column Grouping: 

ORDERBY(SELECT(Unplanned Shipments[ID],AND([Trucking By]=[_THISROW].[Trucking By],[Truck Ref]=[_THISROW].[Truck Ref])),[ULD],TRUE)

Template:

<<Start: SELECT(Unplanned Shipments[ID],AND([ID]=INDEX([GROUP],1),[Trucking By]=[_THISROW].[Trucking By]))>>

<<Start: [GROUP]>>
<<End>>
<<End>>

[Suvrutt_Gurjar]

You are welcome.