4 Replies Latest reply: Mar 13, 2018 4:43 PM by Antonio Domingos Neto RSS

    HOW TO RANK DATE AND VALUE

    Antonio Domingos Neto

      Hi guys!!

       

      I got this table:

       

      rankear.png

      There is showing the TOP and LAST DATES following the expression below:

      ='+' & max(aggr(if(rank(sum(RISCO_C_11_14 + RISCO_D_15_30)/Sum(RISCO_EM_DIA_LAG1),4)=1,DATA_BASE),DATA_BASE))

      & chr(10) &

      '-' & min(aggr(if(rank(-(sum(RISCO_C_11_14 + RISCO_D_15_30)/Sum(RISCO_EM_DIA_LAG1)),4)=1,DATA_BASE),DATA_BASE))


      And now I'm trying to show also que value of the SUM with the DATE, how can I put the expression with?

       

      Tks!!!