Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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
Partner - Master II
Partner - Master II

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