Forum Discussion
Solved
Relationship issues part 2
Here is the scenario. I have three tables of data related by EmployeeID and transaction date. I figured out how to show data in a visual table, but now I have some missing data based on data from o...
Summarising should do the work, if you change the change datatype to text and there is multiple entries for same date, it can only show first or last value.
In recreating what you did using my datasets, I did find that the Ratings "number" is being summarized. When I clicked Do Not Summarize, I lost that other line of data. When I do summarize, it is there. Should I change those rating numbers into Text as they do not need any sums or calculations?
Summarising should do the work, if you change the change datatype to text and there is multiple entries for same date, it can only show first or last value.
- That did seem to do the trick. Thank you for your help