Forum Discussion

Grizman's avatar
Grizman
Icon for Helper I rankHelper I
9 years ago
Solved

Fields

I have two table:     which reveal GrossTurnever=Q-ty*ProductPrice for every year and Margin=GrossTurnever2-GrossTurnever1  
Need Help
  • Thyago_Rezende's avatar
    Thyago_Rezende
    8 years ago

    First picture below shows bi-directional relationship between tables. 

     

    Second picture shows measure for year 2016. 

     

    Hope help you. 

    Best regards,

Grizman's avatar
Grizman
Icon for Helper I rankHelper I
9 years ago

If I transform both columns year and its values in 2 columns I will get many to many relationship because id_product in first and second table will repeat

  • Grizman's avatar
    Grizman
    Icon for Helper I rankHelper I
    9 years ago

    Can you reveal in my example?