I would like to summarize rolled throughput yield by part number in a pivot table.
I can get the throughput yield by operation easily, but I would like the subtotal rows to be the product of all rows included in the subtotal.
One more wrinkle, I would like the Grand Total to be the average of all the subtotal rolled throughputs.
Can this be done?
I can get the throughput yield by operation easily, but I would like the subtotal rows to be the product of all rows included in the subtotal.
One more wrinkle, I would like the Grand Total to be the average of all the subtotal rolled throughputs.
Can this be done?
