povit table colum head

M

Muhammad Usman

i have a problem in povit table, i have the data like

A sep'06 123
B oct'06 001
C sep'06 101

when i drop this data on the povit table it show l
SEP'06 SEP'06 OCT'06 total
A 123 123
B 001 001
C 101 101

Y it no show like
sep'06 oct'06 total
A 123 123
B 001 001
C101 101

please help me out in this proble
 
R

Roger Govier

Hi

It looks like there is a difference in the 2 values of SEP'06.in the
source data.
Perhaps one has an extra space.
Copy one of the values SEP'06 and paste it to the other cell with that
value, then refresh your Pivot Table.
 
Top