14 Replies Latest reply: Mar 16, 2016 12:14 PM by Hugo Ribeiro RSS

    Show number of duplicates in front of each duplicate row

      Hello!

      I have a straight table with a 1st column with distinct values and a 2nd column with values (ID) that are sometimes repeated. How can I show, in a 3rd column, the number of different entries that have the same ID in front of each of those entries (as shown below)?

       

      DateIDTotal number of lines with that ID
      qX2
      wX2
      eY4
      rZ1
      tY4
      yY4
      uY4

       

      This is a straight table that should change depending on the selection made on list boxes (i.e., depending on, for example, the week I select, the number of entries with a certain ID will change...)

       

      Thanks in advance!