4 Replies Latest reply on Sep 14, 2018 5:51 AM by Michael Walischewski

    Counting Rows depending on the details

    Michael Walischewski

      Hi, i have a group of data like that:

       

      Top        Detail        issue    

      ----------------------------------

      1            1             Phone

      1            2             Service

      1            3             Phone

      2            1             Phone

      3            1             Phone

      4            1             Phone

      4            2             Service

      5            1             Phone

       

       

      I need two counts:

      (1) how many Tops with only Phone and without Service in this example 3

      (2) how many Tops with Service no matter if a Phone in the Top in this example 2

       

      I hope it was clear explained. Any ideas?

      thx

      Mike