Forum Discussion
CMSGuy
Helper III
Helper IIIRelationship 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.
CMSGuyHelper III
Helper IIIIn 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?
NaveenGandhi
Memorable Member
Memorable MemberSummarising 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.
- CMSGuyThat did seem to do the trick. Thank you for your help