2 Replies Latest reply: Dec 7, 2017 7:45 PM by Anil Babu RSS

    Comparing two fields on Set Analisys

    Danilo Torres

      Thats my data cloud:

       

      TABLE: ATTENDANCE_REGISTER

      COLUNS: "REG_NUMBER", "YEAR_MONTH_REGISTERED", "YEAR_MONTH_CLOSED", "%KEY_YEAR_MONTH_NUMBER"

       

      TABLE: CLIENT

      COLUNS: "CLI_NUMBER", "YEAR", "MONTH", "%KEY_YEAR_MONTH_NUMBER"

       

      I wanna make a pivot table with these dimensions: "YEAR", "MONTH" and this expression: the quantity of ATTENDENCE_REGISTER that was registered and closed at the same year_month.


      The Set Analisys i'm using is:


      COUNT({<YEAR_MONTH_REGISTERED={'$(=YEAR_MONTH_CLOSED)'}>} REG_NUMBER)

       

      But it doesnt work! Any one help me?


      Thanks!