Pivot Table percentage error

[Anonymous]

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

Regards,

[Anonymous]

like this?

[Anonymous]

no it's wrong the total is not 100%, I already make it right but it becomes null value until I select any category [Cost Sheet Grouping], Once I clear the selection the values become null !!

(sum(Debit02-Credit02)/Sum(Quantity002))/vUnitCost

vUnitCost = =sum({$}Debit02-Credit02)/Sum({$}Quantity002)

[Anonymous]

What is the logic of vUnitCost?

It is something like you are dividing 100 again by 100, how it can be?

[Anonymous]

if this is your requirement, then 2 alternates are:

1) Use Always Selected on Value Option

2) Set a trigger of selection in field on sheet activation