Pivot table - sum of columns

[Guest]

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

 

[Roger Govier]

Hi

From the PT toolbar Table Options>Grand Totals by Row