1 Reply Latest reply: Jul 31, 2017 9:47 PM by Devarasu R RSS

    How to link Transactional table and Goals table with a common office field

    Carlos Enrique Maldonado Corea

      Hi, I have the following situation:

      Office:

      Id        Address

      1          London

      2          Munich   ...

      Customer:

      Id    Name    Office(Afiliation)

      1      Carlos      2

      2      George    1   ....

      Goals:

      (Afiliation) 

      IdOffice  IdCategory    QtyCustomers

      1            1                    3

      1            2                    2

      2            1                    1   ...

      Category:

      Id    Name

      1    Food

      2    Clothes  ...

      Afiliations:

      IdCustomer    IdCategory    Misc      

      2                    1                    AAAA

      1                    2                    BBBB                          

      4                    1                    CCCC    ...


      I need to do an analysis by Office, count the quantity of afiliations per category against the goal set per category to that office. I get the Circular reference warning because office is related to Customer and Goals, Any ideas how to solve this?