Subheaders for matrix

Thanks for the reply from ExcelMonke , please allow me to provide another insight:
Hi,ak77 
Regarding the issue you raised, my solution is as follows:

1.First I have created the following table and the column names and data are the data you have given:

3.Create calculated column references:

sam = 
VAR cc=RANDBETWEEN(0,1)
RETURN IF(cc=1,
"Returns",
"Market value ")

But there are also specific MTD columns, QTD columns, and YTD columns that need to be created based on your specific data structure.

4.Then set the visual object as follows:

5.Here's my final result, which I hope meets your requirements

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.