6 Replies Latest reply on Sep 12, 2019 5:27 AM by Marc Eltvedt

    How do i summarize rows depending on column value?

    Marc Eltvedt

      Hi everyone


      I have the following dataset, and I want to summarize Keys which have status of Error - but which haven't since had an instance that has Status=Completed


      So basically in the view below, ABC and GHI shouldn't be listed, since they have a row where the Status is 'Completed'


      I am struggling somewhat with creating a calculated field which will do this. Any ideas is appreciated.


      Thanks a lot,