Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Cutomize pivot table

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.

1.png

But the pivot table i have created in QV is as below

2.png

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

Community Browser