1 of 1 people found this helpful
It looks like you need a 'Running Product' calculation. This is the same as a running sum, but instead of adding the cumulative field it multiplies.
The syntax you will need is:
I found this solution previously at
I've edited your workbook. The following field will be a bit easier:
SUM(Yield) * PREVIOUS_VALUE(1)
Make sure that the direction of your table calculation is running down the table. Further don't drag a measure onto the rows shelf and wrap it as an attribute to view it as a crosstab. Drag that measure to the text/labels shelf of your marks card. This way it is still treated as a value and you can sort high to low based on it much easier (if you so desire).
yield.twbx 29.6 KB
thanks for your quick and accurate reply.