9 Replies Latest reply on Sep 29, 2018 7:45 AM by philipp.gntzel

    How to exclude not existing values in yoy-comparisons?

    philipp.gntzel

      Hello altogether,

       

      currently I am trying to to some year-on-year comparisons.

       

      Now what I want to do in all my reports to exclude customers who had no record in one of the months of the two years. So if a customer has revenue in 2017 but nothing in 2018 exlude him for the WHOLE year, as well as vice versa. For example to exclude the marked ones on the attached photo.

       

      How can I create a filter which does exactly that? I already tried some LOD but did not come up with a solution here

       

      Best regards,


      Philipp