Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
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

0 Replies