I am returing data from an MS SQL Server database where each row represents a patients visits to a hospital and clinic.
A patient can make many visits so they can be represented by more than one row in the dataset.
I need to count the number of patients. Easy! A distinct count of the patient id field.
I also need to show the percentages of men and women. And then i need to show this in a pie chart.
This is cause me problems.
It must be a pretty standard problem. I have tried using running totals, but then i cant show them in the pie chart.
Anyone any ideas how to solve this?