I want to generate a report that seems like:
I already have a table that has the following columns: [Production ID],[Date of production],[Employee],[Process],[Produced Units].
And I’m using the following expression for the first and second columns (name and production from the 1st of the moth):
<<Start: orderby(SELECT([Related Productions][Production ID], [Process]=Process 1, [Date]=Date(moth([Date of production])&"/1/"&year([Date of production])))),[Employee])>><<[Employee]>><<[Produced units]>><>
That gives me:
Employee 1 2
Employee 3 4
So, when I do similarly for the 2nd of the month, I get:
Employee 1 3
Employee 2 5
As you might see, the Issue is that I need to run the expression with all the “active” employees from that period in order to be able to fulfill the 0’s where needed.
I mandatorily need to filter by date, which will modify the employees on the result. I got to a dead end.
I’ll appreciate any ideas in order to solve this situation.