When using conditional formatting for data labels, as introduced in July 2021, the overall number is used for the calculation, instead of the line number average. Using "data colors > default col...
I too am awaiting a solve for this. For those of us that work with patient Health Data this is a tremendous asset when statistical de-identification is not possible due to sample size.