Hi Mark,
The metric uses "BY ALL OTHER" which is essentially locking the aggregation for that year only. You will need to adjust the by clause to use a connection point in the LDM that allows for the aggregation you would need.
m
Mark Dilson
02/11/2025, 10:38 PM
tried that as well before this post but I was getting the same issue