Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentage of specific amounts in Pivot Table

I am doing financials in qlikview and I need to show in the pivot table % of sales for each row.  See attached screenshot.

For example I am wanting to create a new column title % of sales, it will take each row and divide it by the total of the Title Row "Sales".  See the attached file called excel.

12 Replies
Not applicable
Author

Worked Perferctly, THANKS!!!!!

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Coolio.

Anonymous
Not applicable
Author

I'm using the % of function in a P&L Pivot table, but it's only calculating the base amount as a %, everything else = #N/A. How do I correct this? Capture.PNG