Artificial intelligent assistant

Calculating asset returns by portfolio weights I have a securities portfolio (Fixed Income) and corresponding information regarding the single issues weights (in %) in the portfolio, sector identifiers (i.e. Industrial, Retail) and Total Return quotes %) on a month-to-date basis (MTD). It looks something like this * * * Sid____________Sector__________Weight_____Total Return MTD XS121452838____Industrial______0.0012_____1.25 XS121452816____Retail__________0.0012_____2.25 XS121452822____Retail__________0.0012_____3.25 XS121452811____Utilities_______0.0012_____4.25 XS121452812____Healthcare______0.0012_____-2.21 ## ... How do I calculate sector Total Return? i.e. the total return of all utilities companies in the portfolio (taking their respective weights in this sub-segment into consideration - Portfolio Utilities holdings).

I have added an illustration to aid Ross's Answer for clarity.

Hope the image is legible.![enter image description here](

xcX3v84RxoQ-4GxG32940ukFUIEgYdPy fdf5aac05a7d356a96313803f2717fc2