Solved! Go to Solution.
Thank you Aleksi, the formula you have provided is working and I think it is enough for me
Are you using a Start: & End expression to bring the lines?
Yes, I'm using a star:&End.
In column "No", I Write : <<Start: [Related DBJADIs By NO PACKING]>><<COUNT(SELECT(dbjadi[ID],AND([NO PACKING]=[NO PACKING],[_ROWNUMBER]<=[_THISROW-1].[_ROWNUMBER])))>>. In column "Packing", I Write : <<[QTYPACKING]>><<End>>
Little bit complex but doable with many ways, for example something like this. Though if you are using the same table as this sample, you ned to have min 10 rows in the child table. Another way is to use totally different table that you know there are always min 10 rows.
Nice one Aleksi.
THIS FORMULA WORKS BUT THE CHILD TABLE ONLY CONTAINS 5 ROWS SO ONLY 5 ROWS APPEAR. CAN YOU EXPLAIN OTHER EXAMPLES OF FORMULA TAKEN FROM DIFFERENT TABLES AS YOU MENTIONED?
Need to find a sample.. little bit more complex.
Thank you Aleksi, the formula you have provided is working and I think it is enough for me
Okay good ๐
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |