Pivot Table Total

[#1]

Hi! I would like to have the types (recent, inpatient and outpatient) on the horizontal axis at the top and add a total column that counts the number of patients from each country. So for UAE, I want to show Inpatient (5) Recent (15) and Outpatient (23) at the top with a total of 43 on the right hand side. Any ideas?

[#2]

Hi,

Put your cursor on type and hold right click till a blue line appears, drag the line above MRN Count till it becomes horizontal. Go to Presentation tab click on Country and check the show Partial Totals.

I believe that should lead you to the view you are looking for.

Regards

Rahul

[#3]

Yes – that worked perfectly. Thanks!