Help needed to sort the values

[#1]

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

[giakoum]

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

];