PIVOTE

[#1]

Hi All,

I have a pivote table

Table 1

PHYSICIAN	VOLUME (=SUM(VOLUME))
OTHERS	88207
JOHN	607
LIMI	602
TOMMY	689
JOHNY	794
HENCL	490
DENSON	635
GILBERG	226

Table 2

1) Intially "OTHERS" was blank in the DM so it was   coming at the bottom like (Shown below)
PHYSICIAN	VOLUME
JOHN	607
LIMI	602
TOMMY	689
JOHNY	794
HENCL	490
DENSON	635
GILBERG	226
	88207

Table 3

2) Now we have renamed "Blank" as OTHERS which is coming in the top ("Shown in the table no 1")
PHYSICIAN	VOLUME
JOHN	607
LIMI	602
TOMMY	689
JOHNY	794
HENCL	490
DENSON	635
GILBERG	226
OTHER	88207

Result:

  Actually we want as "OTHERS" to display below as shown in the above table (Table 3)

Thanks,

GP