Hi everybody, I want to order the dimension called sub reason by %/total expression in descending way by subreason but I can't.
This is the calculation for the expression:
=if(Dimensionality()=1,
count({<action={'contact'},AñoMes_Nro = {$(vAnoMesAnt)}>} self_support_logid)
/count(total {<action={'contact'},AñoMes_Nro = {$(vAnoMesAnt)}>} self_support_logid),
if(Dimensionality()=2,count( total <sub_reason_c> {<action={'contact'},AñoMes_Nro = {$(vAnoMesAnt)}>} self_support_logid)
/count(total <main_reason> {<action={'contact'},AñoMes_Nro = {$(vAnoMesAnt)}>} self_support_logid)))
And I am trying to sort by this expression:
count( total <sub_reason_c> {<action={'contact'},AñoMes_Nro = {$(vAnoMesAnt)}>} self_support_logid)
I attach the .qvw file. The problem is in CX tab.
Thanks!