Forum Discussion

emma313823's avatar
emma313823
Icon for Helper V rankHelper V
9 years ago

Creating many to many relationship

Hi All   I have a dashboard I'd like to create using two exported excel spreadsheets.   Export 1: has a unique customer ID the software creates we have had a custom field added which allows us ...
Need Help
Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
9 years ago

Hi emma ,

 

For achieve this u have to create one intermediate table called factless fact table.

 

so create one calculate table with only unique customer ID.

 

like 

Calculated table = Values("Customer ID from Table")

 

if customer coming from two different table no problem create one more  table and union this two table as one table.

 

let me know any question