Forum Discussion

timazarj's avatar
timazarj
Helper II
5 years ago
Solved

Table relationships

Hi,

 

in my model I have a Date table, using it a slicer, Employee table, using it for usercode. there are 2 different tables for Sales and Returns. I created the relationship between the Date to Sales & Returns to filter the monthly sales and returns. Also created a relationship and connect Employee to Sales & Return to show the employees' name rather than the codes and also be able to filte the names in the report. the relationships are 1-* and single. Now that I run the report it works well for the returns but not for the sales, the numbers are blank. Please advise me.

  • timazarj,

    Date(Date and Sales Table) is the culprit. Make sure that you have matching records for Date.

12 Replies

    • timazarj's avatar
      timazarj
      Helper II

       

      The right side should show the sales diagram and numbers which are blank now.