Cutomize pivot table

Tue, 10 Jul 2012 06:26:43 GMT

Hi All,

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

calculated.

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

Agreements

Misc./General Advice

Opinions

Domain Names

Acquisitions/Divestitures

Other

Please a solution for this.

Regards,

Gerard

topic Cutomize pivot table in QlikView

Cutomize pivot table