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