I use same formula to get territory name with maximum naïve pts. I am having problem with getting new prescriber number related to that territory (territory with maximum naïve pts).
I am trying to get that value with this formula:
num#(sum(aggr( NEW_PRESCRIBERS_YTD , only vnew_prescriber_territory)),[HUB ID]) & chr(32)
it's giving me 0 as an answer.