Pivot table question

[TC123]

Hello,

I'm hoping someone can help. I have a pivot table and one of the fields is Sequence ID (which is the number of wards a patient has stayed on in a hospital, eg 1,2,3,4). I also have the field of Visit ID (which is a unique reference number for each patient).
What I want to do is calculate how many patients were on 1 ward, how many patients were on 2 wards etc......
However, I can't figure out how to do this. As when I pull sequence ID into the Values section and Visit ID into the Row Labels I am getting the individual patients instead of how many patients as a whole stayed on 1, 2 or 3 wards for example. Can anyone help me?

Thanks

 

[Richard Schollar]

Don't you want Sequence ID in the row fields and Visit ID as the Values field?