Custom Ordering

[#1]

INFORMATION IN THIS FILE IS FICTITOUS

Attached is a .qvw FILE

This is a pivot table.  How can I custom order MGMM, PPGM, PRGM (Within Job COLUMN) to display in the following order:

PPGM     PRGM     MGMM

[jerem1234 · Accepted solution]

You can use this expression for sorting on your Job dimension under the Sort tab:

match(Job, 'PPGM', 'PRGM', 'MGMM')

Hope this helps!

[MK_QSL]

Go to sort tab

Select Job

Under expression type below and select Ascending

Match(Job,'PPGM','PRGM','MGMM')

[Nicole-Smith]

[alexandros17]

In the sort tab click Job, uncheck ordering by text and check expression (set ascending) and write in it:

if(Job='PPGM',1, if(Job='PRGM',2,3))

Hope it helps

[#6]

Thank you for taking time respond.  this option works too.

[#7]

Thank you for taking time to respond. This option works too.

[#8]

Thank you for taking time to respond, this option works

[#9]

Thank you for taking time to respond this option works.

[#10]

yes, match function is very helpful when you have specific sort order for limited no. of field values