May 12, 2008 #1 tsuable Programmer Joined Feb 2, 2005 Messages 41 Location US Hi, My data source looks like this Patient ID Wound ID 1 1 1 2 1 3 2 1 2 2 2 3 I am doing this through impromptu. The patient Count should be 2 and wound count should be 6
Hi, My data source looks like this Patient ID Wound ID 1 1 1 2 1 3 2 1 2 2 2 3 I am doing this through impromptu. The patient Count should be 2 and wound count should be 6
May 14, 2008 #2 blom0344 Technical User Joined Mar 20, 2002 Messages 3,441 Location NL Use 'count distinct' for patientID and 'count' for Wound ID.. Ties Blom Upvote 0 Downvote