I’ve tried various LOD expressions and table calcs but I’m unable to find a solution.
I’m trying to create a custom subtotal (sum of the weighted averages) for the YTM column. I want the subtotals for TSP and TAC to remain as sums.
Below is an example - I would like the subtotal in the Yield to Maturity field to be 0.40 while the row level values for the YTM do not change. The row level weighted averages are calculated as follows: TSP/SUM(TSP)*YTM (e.g. the weighted average for SecA is (30,000,000/48,709,000*0.4 = 0.25)).