Something like this?
I've used LOD expressions for CY Avg / Max / Min,
the same could be achieved with Table Calculations, though.
Please find the attached.
Thank you so much for your help, that solves my problem.
I have 2 flow-on questions which I will post in a new discussion