Yes; Hui.
I followed Manual options to rearrange the field.
But however i wonder; then why do we need to have PIVOT TABLE OPTIONS->DATA SOURCE ORDER?
Where does it use?
thanks
Hi There
I have the following the data in row in excel
M
C
C
C
C
C
C
C
D
D
D
D
D
I
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
W
W
W
W
W
J
C
C
C
C
C
C
C
C
C
C
C
C
I
I
I
I
I
I
I
I
I
I
L
L
when i pivot it; the unique values display in the...