I have a table showing applications by source, pivoted by gender.
I want to apply conditional formatting (high to low) on each measure to show, for each gender, which sources has the most applications, share of applications, etc.
However, the conditional formatting seems to take into account all values, not just the ones in the pivoted column (e.g. female applications, high to low).
Is there any way to do this?