Pivot Table percentage error

[Anonymous]

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

Regards,

[Chanty4u]

hi,

[tresesco]

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]

can I solve it without variable ?!

[Anonymous]

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

sorry

[Anonymous]

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

[tresesco]

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]

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

[Anonymous]

(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%