Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Can't determine relationships between the fields.

I have two datasheets, one containing annual costs by month and bank account, and the other one contains datailed informations about the cost on its respective bank account.   AnnualCosts          ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous,

 

I don't think you can direct use both side table columns to create visual. In my opinion, I'd like to suggest you use bridge table column instead the original relationship columns to link those fields from different tables.

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous, it worked. I created a new column named "AccountID" on my bridge table and merged that new column with the other two. But if I want to display the BankAccount of each table in the same visual, I can't show all as "Don't summarize", one on them has to be "Sum". Can you explain me what is happening? Why this error happens?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Anonymous,


    How did you create the visual, can you please share more detail?

     

    You can create table visual like below, bold part can store records with 'Don't summarize' mode:

    Razao columns(mutiple), Conta column, Opex columns(mutiple).

     

    Regards,
    Xiaoxin Sheng