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

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

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

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

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

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

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

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

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