Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
the table structure is like :
date | stage | status | amount | index
there are 7 processes and every process has 4 kinds of status (pass,fail,rework,scrapped). Now, I need to make a table like this:
the first pass = pass count / total
cumulative first pass = the current ratio of first pass * the previous ratio
These process are in order and the filed index means their sequence number.
Now I am using a plug-in called transpose table and I have successfully created all measurements except for the ratio of cumulative first pass, because I have no idea how I can get the ratio of first pass of the previous process.
Many thanks
You'll need to use either the above() or before() functions depending on your table setup.
You'll need to use either the above() or before() functions depending on your table setup.