How to create a pivot table like this...

[#1]

What kind of expressions do I use to create a pivot table like this?

Any help would be much appreciated!

[simenkg · Accepted solution]

alt(only([Machine Start]) - above(only([Machine Stop])),0)

[#3]

Sorry, I'm painfully new to this, could you specify a bit more?

Is this correct - My dimensions are: Machine, Operator, Program, Start.

[simenkg]

The above functions should return the value for the line above it. So Machine Start - Above (Machine Stop) should give you the time between production.

If that is not your desired result then you need to specify your expectations.