iterate through another table

[Anonymous]

Hi, 

I have a still to do list of task pr productionsection and these task have different order of handling, so one task needs to be finished first before another one should start. I only wants to show the task that currently needs to be carry out. I need some kind of dummy in a calculated column.
example:
task B needs to be finish before C and C before D,  A Can be start anytime and should show in the list regardless.  

The
 productsection    task    dummy (filter later in report)
1.                          A              1
1.                          B.              1
1.                         C                0
1.                        D                  0
2.                        A                 1

2.                       C                   1

2.                       D                   0

2.                       E                   0


Desired list
1.A
1.B

2.A

2.C

[Anonymous]

Hi @Anonymous ,

Has the problem be solved?

Best Regards,

Jay

[FrankAT]

Hi @Anonymous 

you can do it like this:

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[zzzeagle]

How about this?

1. Duplicate the original task list twice
2. In the first, filter where task = A
3. In the secon, filter where task != A, then group by ProductSection and use the Min of Task
4. Append the two copies of the task list
5. Merge the appended lists to the original task list