I have attached a QV application, which will have a pivot table.
Below is the format of a excel which need to be achieved in pivot table. Spend category field is categorized as shown in the picture and sub total has been
But the pivot table i have created in QV is as below
How can we get the exact format of excel in pivot table for spend category.
Either we need to get the order of spend category for dept 860030 or we need to get the exact excel format.
|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|
Please a solution for this.