View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LauriS LauriS is offline
external usenet poster
 
Posts: 32
Default Pivot table - sum of columns

Here's the data - sheet has columns for Doctors name, facility, diagnosis,
date (and other misc. info) and then 6 columns that define why the patient
was declined. User places an X in the appropriate column.

I created a PT that shows the total count of Xs for each declined reason, by
Doctor, Facility and Diagnosis. So the PT looks like this:

Reason A Reason B Reaons C ...
Doctor Facility Diagnosis 5 7 9

I have totals at the bottom of the columns (total count of declines by
Reason) but I need totals to the right (totals declines per row - Doctor,
Facility, Diagnosis). Is there a way to do that other than a normal SUM
function?

Thanks!

Lauri