Forum Discussion

MP-iCONN's avatar
MP-iCONN
Icon for Resolver I rankResolver I
3 years ago
Solved

Distinct count from another non related table

I have two tables, one for quotes and one for orders.  Now the only relatable data I can think of is the Branch but just wondering if there is a way to get these two numbers possibly toghether, maybe in a new table if that is needed so I can get percentages of Quotes to Orders.  Thank you for any advice or help on this.

 

 

 

 

Need Help
  • Avantika-Thakur's avatar
    Avantika-Thakur
    3 years ago

    Hi MP-iCONN ,

     

    You can try the below steps :

    1) Create a common Lookup table for Branch with all the existing branches

    2) Create a relationship of this Branch Lookup table with both Quotes and Orders table based on the Branch column/ Branch ID column if it exists as shown below :

    3) Then you can pull the Branch column from the Branch lookup into the Matrix grid and Quotes and orders column from their respective tables and can also build a measure for calculation percentage with these 2 columns

     

    Hope this helps!

     

    Please accept the solution if this answers your query.

     

    Thanks,

    Avantika Thakur

     

2 Replies

  • Avantika-Thakur's avatar
    Avantika-Thakur
    Icon for Solution Supplier rankSolution Supplier
    3 years ago

    Hi MP-iCONN ,

     

    You can try the below steps :

    1) Create a common Lookup table for Branch with all the existing branches

    2) Create a relationship of this Branch Lookup table with both Quotes and Orders table based on the Branch column/ Branch ID column if it exists as shown below :

    3) Then you can pull the Branch column from the Branch lookup into the Matrix grid and Quotes and orders column from their respective tables and can also build a measure for calculation percentage with these 2 columns

     

    Hope this helps!

     

    Please accept the solution if this answers your query.

     

    Thanks,

    Avantika Thakur