Sorting order of the column gets changed on 11.20 SR10

[jegadeesan]

Hi All,

Sorting order of the column gets changed in 11.20 SR10 for every reload when its not in version 12.10 SR1. Am getting this trouble while using calculated dimensions....

Any idea?

Regards,

Jegadeesan G

[Anil_Babu_Samineni]

Can you share that Calculated dimension with us? Will look in to that if you share

[jegadeesan]

HI Anil,

Thanks... Here is the dim

=if(aggr(rank(

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

/

sum(TOTAL{<IMSMonthName,IMSYear,DATAPERIOD = {">=$(=date(addmonths(date#(max(DATAPERIOD),'YYYYMM'),-11),'YYYYMM'))  <=$(=max(DATAPERIOD))"}>}NVALUE))*100),COMD)<=20,COMD,'Others')

[Anil_Babu_Samineni]

Do you done sorting default options or by using expression?

May be try this with expression enable on sorting

=if(aggr(rank(

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

/

sum(TOTAL{<IMSMonthName,IMSYear,DATAPERIOD = {">=$(=date(addmonths(date#(max({1}DATAPERIOD),'YYYYMM'),-11),'YYYYMM'))  <=$(=max({1}DATAPERIOD))"}>}NVALUE))*100),COMD)<=20,COMD,'Others')

[jegadeesan]

Anil,

Getting the same issue yet and sorted thru default options...

Regards,

Jegadeesan

[jegadeesan]

and tried with expression enabled option... getting the same issue yet...

[jegadeesan]

and tried with expression enabled option... getting the same issue yet...