4 Replies Latest reply: Nov 8, 2010 5:27 AM by EduardoGonzalez RSS

    How to get the TOTAL from a Top3 in a Straight Table

      Hi everyone,

      I have a table like this

      HOTEL Noches Precio Media rank([Noches],4,2)
      E5490981
      D44001002
      C320066,66666666666673
      B2180904
      A11001005
      TOTALES15137091,3333333333333

       

      And I´d like to have a Top 3 table with TOTALS, where the Total of the 3º Column is the most important, cause it must be not the AVG of the values on the 3º Column, It must be (Sum of Total Values in 2º column) / (Sum of Total Values in 1º column).

      So now I use the ranking to show only values when ranking is <= 3 and null when ranking isn´t, and I have this

      HOTEL Noches2 Precio2 Media2



      E549098



      D4400100



      C320066,6666666666667



      A






      B






      TOTALES121090




      But Then I´d like to have something like this

      HOTEL Noches2 Precio2 Media2



      E549098



      D4400100



      C320066,6666666666667



      TOTALES12
      1090
      90,8333333333




       

      How can I get it?

      Thanks a lot