Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Using column from another table for percentile calculation

Hi, I am trying to calculate percentiles for my sales (coming from 'coverage_revenue' table) but I need to use an ID column in another table ('table_b'). I understand I will need to use the RELATED f...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , related work in 1-M relationship to bring data from 1 side to M side

 

refer this, if this can help

Relatedtable, Related -https://youtu.be/Wu1mWxR23jU

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for the video link, helped me understand a few things but have not resolved my problem. 

    Turns out the relationship between the two tables cannot be created between the ID columns because of a many to many relationship (both tables with the ID column have duplicate IDs). Is there any other way I can use the ID column from tableB over tableA in my rankx measure?