Rank Issue

[dineshm030]

Hi All,

I selected MUMBAI region. In that region AMARYL M rank is 3. But in main table it is showing as rank 3. I need it should be shown as rank 3.

Could u pls help me.

Thanks in advance.

[dineshm030]

In Main table it showing as rank 1

[sunny_talwar]

What is your rank expression look like?

[dineshm030]

but it should be coming based on subgroup.

Aggr(Rank(sum({<IMSMonthName,IMSYear,DATAPERIOD = {">=$(=date(addmonths(date#(max(DATAPERIOD),'YYYYMM'),-11),'YYYYMM'))  <=$(=max(DATAPERIOD))"}>}NVALUE),1,1),Region,SUBGROUP)

[sunny_talwar]

So what is the link between Region Mumbai and  Brands AMARYL M? Why do you need AMARLY M's Rank and why not GEMER?

[dineshm030]

its for example. if i select GEMER it should be as Rank 2

[dineshm030]

here it is in second rank for chennai region

[sunny_talwar]

Each Region have only a single Brand?

[dineshm030]

no sunny... it has mutiple brands

[sunny_talwar]

I am not sure I understand the Ranks you are looking to get.. would you be able to share a sample and elaborate on the expected output?