Percentage in pivot table

[Anonymous]

I have two table and ,

in table , I have (Item) and (Quantity/Ton)

in table , I have (debit) and (credit)

>> The "Balance" = (debit - credit)

** the relation between this two tables is the date only.

-------------------------------------------------------

how can I calculate the Qty% and Qty*total Balance/Total Qty in qlikview using pivot table ?!!

every time I try I faced problem with duplicate in data.

sorry for bad English.

Regards,

[Gysbert_Wassenaar]

[Qty%]: Sum([Quantity/Ton])/Sum(Total [Quantity/Ton])

[Total Balance]: rangesum( sum(total debit), -sum(total credit))

Qty*total Balance/Total Qty: sum([Quantity/Ton]) * [Total Balance] / sum(Total [Quantity/Ton])

And if that doesn't work that means I don't have enough information to make a good guess. In that case please post a small qlikview document that illustrates the problem.