I am calculating Yield by using the following pattern: SUM([Passes]) / SUM([Quantity])

With the following data set:

Normally I would use this method (Based on excel's product function): Running Product but, I just want to display the outcome in a single cell (43%) rather than all the rows and columns and put it in the corner of my dashboard.

Is that possible? I tried to use running product, but when i remove Test and Product it shows 95% when in fact it should show 43%

Just create a calculated field with the table calculation LAST()=0. This will result in a Boolean that is true when you have the last value of your partition. Now put this new calculated field on the Filter Shelf and filter "True" (make sure that your table calculation is addressed to Test and Product). Now just move Test and Product to Detail on the Mark Shelf. Now you are good to go.

Please find it attached. In there you can find data: Test, Products, Passes and Quantity. In the workbook we calculate [Yield] with sum of [Passes] / [Quantity] and then we calculate Running Yield with EXP(RUNNING_SUM(LN([Yield]))). The final outcome is in the other sheet. I would like to display the last value of Running Yield, which is basically [Yield] of every [Test], [Product] multiplied.