Forum Discussion

Oros's avatar
Oros
Post Prodigy
2 years ago
Solved

Relate tables

Hello,   I have 3 tables (DOLLAR and QTY tables are related with the third table PRODUCT).   The DOLLAR and QTY columns are correct, but as soon as I bring in the CUSTOMER column the QTY for each...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Create a single column table of all unique customers.  Create a Many to One relationship from the Qty and Dollar Table to the Customer Table.  To your visual, drag Customer from the Customer Table.

    Hope this helps.

Oros's avatar
Oros
Post Prodigy
2 years ago

Hi aj1973 ,

 

Thank you for your quick reply.  I changed the relationship as you indicated.  But it looks like only the total is correct. COuld it be because the CUSTOMER from the DOLLAR and QTY tables must also be related?  Thanks again.

 

The QTY lines are duplicated and do not equal the total qty of 2,165.38.

The matrix table is also not correct because of duplicated QTY.

 

In Excel Pivot Table, this are the correct numbers.

 

 

 

 

 

aj1973's avatar
aj1973
Community Champion
2 years ago

Oros New Update:

 

Use CUSTOMER from the DOLLAR Table instead

 

 

And Use Product from the Dollar Table

 

  • Oros's avatar
    Oros
    Post Prodigy
    2 years ago

    Hello aj1973 ,

     

    Unfortunately, the result is still incorrect.  The QTY column still shows duplicate values.  How do we avoid the duplicate values and show the correct values instead?  Thanks.

     

    • aj1973's avatar
      aj1973
      Community Champion
      2 years ago

       

      • Oros's avatar
        Oros
        Post Prodigy
        2 years ago

        Hi aj1973 ,

         

        Thanks again for your reply. 

         

        Unfortunately, the duplicate (incorrect) values still show up in the QTY column.