Replace if with pick match

[Jeff2]

How would a rewrite this with pick match.

Sum(if(PSortKey='Female',PCases))

Thanks

[Kushal_Chawda]

@Jeff2  I would say set analysis will be better option here than pick match

Sum({<PSortKey={'Female'}>}PCases)

[Jeff2 · Accepted solution]

Great thanks

[Kushal_Chawda]

@Jeff2  close the thread by accepting solution