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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table Anomoly
I'd look for duplicate headers in your raw data.
Trevor Aiston wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table Anomoly
Maybe these ones are groups of items names. Right click on one of those
cells and click upon "ungroup". HTH Daniel 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table Anomoly
Right clicked items in raw data and they don't show as groups?
"Daniel.C" wrote: Maybe these ones are groups of items names. Right click on one of those cells and click upon "ungroup". HTH Daniel 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table Anomoly
Thanks dave but no dulicate colum headers.
The colums containing the data are headed 6 ProvDiag 7 EstDiag Each pivot table only counts one column of data "Dave Peterson" wrote: I'd look for duplicate headers in your raw data. Trevor Aiston wrote: 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 -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table Anomoly
No. right click on "Alzheimer's Disease2"for instance, in the pivot
table. Daniel Right clicked items in raw data and they don't show as groups? "Daniel.C" wrote: Maybe these ones are groups of items names. Right click on one of those cells and click upon "ungroup". HTH Daniel 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table Anomoly
Doh, sorry daniel.
Nope that did not work either "Daniel.C" wrote: No. right click on "Alzheimer's Disease2"for instance, in the pivot table. Daniel Right clicked items in raw data and they don't show as groups? "Daniel.C" wrote: Maybe these ones are groups of items names. Right click on one of those cells and click upon "ungroup". HTH Daniel 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table Anomoly
Then, there is a possibility that the items have been modified
manually. Can you rebuild the pivot table ? Daniel Doh, sorry daniel. Nope that did not work either "Daniel.C" wrote: No. right click on "Alzheimer's Disease2"for instance, in the pivot table. Daniel Right clicked items in raw data and they don't show as groups? "Daniel.C" wrote: Maybe these ones are groups of items names. Right click on one of those cells and click upon "ungroup". HTH Daniel 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Pivot Table Anomoly
Refreshing did not work, but creating a new table did thanks.
"Daniel.C" wrote: Then, there is a possibility that the items have been modified manually. Can you rebuild the pivot table ? Daniel Doh, sorry daniel. Nope that did not work either "Daniel.C" wrote: No. right click on "Alzheimer's Disease2"for instance, in the pivot table. Daniel Right clicked items in raw data and they don't show as groups? "Daniel.C" wrote: Maybe these ones are groups of items names. Right click on one of those cells and click upon "ungroup". HTH Daniel 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 |
Reply |
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 |