Help needed to sort the values

Tue, 10 Jul 2012 07:25:59 GMT

Hi All,

I have attached a sample QV. Please provide a solution to sort the order of the spend category in the table .

Order to be in

US TM Outside Counsel Fees & Exp.

US TM Gov't Fee

Int'l TM Reg./Pros. Fees & Disb.

Int'l TM Gov't Fee

Int'l TM Renewals

Agreements

Misc./General Advice

Opinions

Domain Names

Acquisitions/Divestitures

Other

Regards,

Gerard

Re: Help needed to sort the values

giakoum — Tue, 10 Jul 2012 07:33:44 GMT

Use an inline table to order them as follows :

[Order]:

LOAD * INLINE [

Spend Category, Order

Other, 5

"Int'l TM Reg./Pros. Fees & Disb.", 4

Misc./General Advice, 6

Agreements, 3

US TM Outside Counsel Fees & Expenses, 2

Acquisitions/Divestitures, 7

Domain Names, 8

"Int'l TM Gov't Fee", 11

"US TM Gov't Fee", 1

Opinions, 9

"Int'l TM Renewals", 10

];