Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table with more than 3 columns | Excel Worksheet Functions | |||
How do I get more columns in a pivot table? | Excel Discussion (Misc queries) | |||
How do I get more columns in a pivot table? | Excel Discussion (Misc queries) | |||
Pivot Table Columns | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |