Hi everybody, I want to order the dimension called sub reason by %/total expression in descending way by subreason but I can't.
![Captura de Pantalla 2020-02-21 a la(s) 10.14.05.png Captura de Pantalla 2020-02-21 a la(s) 10.14.05.png](https://community.qlik.com/t5/image/serverpage/image-id/28865iD01C09D7E42965EF/image-dimensions/655x288?v=v2)
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!