Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table Anomoly
I have a workbook in Excel 2003 which has a worksheet contain <100 records of
patient diagnosis. When I do a pivot table to do a €˜count of diagnosis it returns the count of diagnosis but bizarrely adds a 2 to the end of some diagnosis labels. Count of BPD BPD Total (blank) Acute Polymorphic Psychotic Disorder 1 Acute Psychosis 3 Acute Psychotic Episode 2 Alcohol Dependence 3 Alzheimer's Disease2 1 Anorexia Nervosa 1 Bipolar Effective Disorder 5 BPD 1 Chronic Alcohol Dependence 1 Dementia/Schizophrenia 1 Dementia2 1 Depression 2 Drug induced psychosis 1 Emotionally Unstable PD 2 Generalised Anxiety Disorder 1 Hebephrenic Schizophrenia2 1 Heroin Dependence2 1 Mania 1 Mixed Dementia 1 Mixed Vascular Dementia 1 Paranoid Personality Disorder 1 Paranoid Psychosis2 2 Paranoid Schizophrenia2 5 PD 1 Recurrent Depressive Disorder 2 Schizoid Affective Disorder 3 Schizophrenia 8 Severe Depression 3 Vascular Dementia 5 Grand Total 61 Yet exactly the same data from another column is labelled ok.. Any idea why this should be. Thanks Trevor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Pivot Table | Excel Discussion (Misc queries) | |||
RESTRICT PIVOT TABLE IN EXCEL 2003 | Excel Discussion (Misc queries) | |||
How to schedule a pivot table in excel 2003? | Excel Discussion (Misc queries) | |||
Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
Referring to Pivot Table in Excel 2003 | Excel Worksheet Functions |