2 Replies Latest reply: Mar 18, 2015 5:48 AM by Ananth Reddy RSS

    Alternate rows sum in straight table

    Ananth Reddy

      Hi QV,

       

      I have below data :

       

      IDValue
      33354
      77744
      55536
      22234
      11123
      44411
      6665

       

      Now in a straight table based on rank(value) I need table should look like below :

       

      IDValueranksum
      333541118
      777442118
      555363118
      222344118
      111235118
      444116118
      66657118

       

      Could anyone tell me how to write expr for sum above.

      here sum is calculated by adding the odd rows i.e. if rank equals to 1/3/5/7... then I need to sum the Value.

       

      Thanks,

      Ananth