9 Replies Latest reply: Mar 22, 2016 6:46 AM by Sunny Talwar RSS

    how to highlight a row based on existence of another row

    Pavel Krouglov

      I've got the following table

      row_id,date_id,event_id,event_type, customer,value

      1,1,1,t,a,10

      2,2,2,t,a,15

      3,2,2,t,a,20

      4,2,7,t,b,17

      5,3,100,v,a

      6,3,200,v,a

      7,5,3,t,b,30

      8,6,3,t,b,50

      9,7,4,t,a,100

      10,8,4,t,a,12

      11,9,5,t,a,18

       

      I am showing that data in a straight table.

      How can i

      1) highlight rows where event_type = 't' and for the same customer could be found a row with event_type='v'.

      In the sample i would highlight rows 1,2,3,9,10,11

      2) highlight rows with the same event_id where event_type = 't' and next (in order of date_id) event for the same customer is an event where event_type = 'v'

      In the sample i would highlight rows 2,3


      Is that possible without script calculations?