Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot Table percentage error

I need help to fix the problem with pivot table percentage!

Untitled.png

Regards,

13 Replies
Chanty4u
MVP
MVP

hi,

tresesco
MVP
MVP

Your variable vUnitCost is evaluating to 0 (zero). Is that right?

avinashelite

could you please explain on which conditions we need to do the aggr ?

Anonymous
Not applicable
Author

can I solve it without variable ?!

Anonymous
Not applicable
Author

with [cost sheet grouping], [Account_No02] and [Item_Name002] . by the way I am not sure because I'm lost !

sorry

Anonymous
Not applicable
Author

the total is not 100% !! can you check it again please..

tresesco
MVP
MVP

To suggest that, I have to understand your model/data - which would be a time consuming process here. Unit cost in the column before, is totally different than your % calculation formula ! Aren't they related? What is your expected output?

Anonymous
Not applicable
Author

Could you share the metrics, on what basis you are calculating Unit_Cost%???

Anonymous
Not applicable
Author

(sum(Debit02-Credit02)/ sum(Quantity002)) this is the calculating for unit cost,, I need Unit Cost % for each [Account_No02] and the total of them 100%