Help - Need to pick last operation per department to calculate output

[#1]

Hi,

Need to cacluated Qty Completed for the last operation for the department to calculate output per department.

Below is a simple example for one production order. In this case I need some help to 1) flag the last operation in script and then sum it in pivot, or 2) calculate this in expression. I am thinking that firstorted value can be used?

Hope someone can offer their advise.

Operation	Work Center	Department	Qty Completed	Date
10	CSW230	Machine	20	02.08.2014
20	CSW310	Hardening	20	03.08.2014
30	CSW320	Hardening	20	03.08.2014
40	CSW410	Surface	18	05.08.2014
50	CSW420	Surface	16	06.08.2014
Intended result:
	Department Qty Completed Machine 20 Hardening 20 Surface 16

[maxgro · Accepted solution]

PFA attachment

[#3]

Thanks a lot! Just what was needed.

Best regards,
Freddy