PIVOTE

Wed, 14 May 2014 16:49:02 GMT

Hi All,

I have a pivote table

Table 1

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,

topic PIVOTE in QlikView