How to change the order of cell values in dimension in Pivot table?

[#1]

Hi,

I have below script in qvw

If(MixMatch([Computer Stage],'DELL'),'Station 1',

     If(MixMatch([Computer Stage],'HP',

     'VAIO',

     'INNOVA'),'Former Station 1',

     If(MixMatch([Computer Stage],'PC Application'),'PC Ordered',

     If(MixMatch([Computer Stage],

     'Final DELL - Allocation',

     'Final HP'),'PC Delivered',

If(MixMatch([Computer Stage],'Dockure'),'PC Price',

  If(MixMatch([Computer Stage],

'TOSHIBA'),'Confirmed',

If(MixMatch([Computer Stage],'DELLITE'),'Monitored', [Computer Stage]))))))) as Flag

by using this I have created a pivot table as shown below

Computer Stage	CEO	Manager	Team Leader	Team Member
Former Station 1	1	7	20
Station 1				8
PC Delivered		7	9	0
PC Ordered
Confirmed		12
Monitored		89		90
PC Price

All I need output is as below I,e to change the order of Computer Stage as below.

Computer Stage	CEO	Manager	Team Leader	Team Member
Station 1	1	7	20
Former Station 1				8
PC Ordered		7	9	0
PC Delivered
PC Price		12
Confirmed		89		90
Monitored

Would it be possible? Please can anyone suggest me.

Thanks.

[sunny_talwar]

If these are the only ones that can appear within Computer Stage, you can try the manual sort order:

Match([Computer Stage], 'Station 1', 'Former Station 1', 'PC Ordered', 'PC Delivered', 'PC Price', 'Confirmed', 'Monitored')

I think this should work

Best,

Sunny

[ashfaq_haseeb]

Hi,

Try this as your sort Expression

=Dual("Computer Stage",match("Computer Stage" ,'Station 1','Former Station 1','PC Ordered','PC Delivered','PC Price','Confirmed','Monitored'))

Regards

ASHFAQ

[robert_mika · Accepted solution]

Or in script:

If(MixMatch([Computer Stage],'DELL'),Dual(Station 1',1),If(  If(MixMatch([Computer Stage],'HP', 'VAIO', 'INNOVA'),Dual('Former Station 1',2) ................

More about Dual:

How to use- Dual()

[#5]

Thanks. That worked.