5 Replies Latest reply: Mar 13, 2018 9:42 AM by Jahanzeb Hashmi RSS

    set modifiers to compare two dimensions

    Caroline Huet

      Hello,

       

      I have the two following tables :

      OldTable :

      IDOld Standard
      1ST1
      2ST2
      3ST2
      4ST2

       

      NewTable

       

      IDNew Standard
      1ST1
      2ST2
      3ST2
      4ST1

       

      And I would like to have a KPI to count the number of Standard difference between the two tables, that is to say : count(DISTINCT MSN where New Standard is different from Old Standard) but I don't manage to do that.

       

      I don't want to join tables because I have a lot of others columns so it will be very heavy and I need each table to be independant.

       

      If you have any idea, don't hesitate

       

      best regards