I would like to do conditional formatting on Average of Group Net Result and compare with individual Net Result.
My Net result calculation(from my actual data) is a measure.
Please see masked data for reference.
for eg, I cannot highlight Cost Center 1008 because it is better than Metro Group - 50 Beds to 70 Beds average.
I do not have correct Average for the group. In my live data, Net result was a measure.
Please let me know if you require further information.