Hey there,

I'm trying to determine how to only display on a map if a state has more male births or female births.

I have attached my worksheet to provide more clear information.

My dataset has Gender as a Dimension and (Number of) Births as a measure. I am really stumped.

I've tried to seperate gender birth measures by making calulated fields of Male Births and Female Births and trying to have another calculated field to return the larger value, but it doesn't seem work.

Thanks for your help in advance.