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

Pivot table - sum of columns
 

Hi

From the PT toolbar Table OptionsGrand Totals by Row

--
Regards

Roger Govier


"LauriS" wrote in message
...
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