Expression

[Anonymous]

How can I using this expression with right way:

( Qty * sum(Balance) ) / (sum (Qty)

I have table contain Item, Qty and Balance.

[jonathandienst]

Perhaps this (weighted average):

Sum(Qty * Balance) / Sum(Qty)

[sunny_talwar]

May be this:

Sum(Balance * Qty)/Sum(Qty)

[Anonymous]

Sorry, I explain it with wrong way

I need to make percentage for each Quantity   >>> single quantity / total quantity

= Qty / sum(Qty)

= Qty / sum(Qty)

[arulsettu]

try this

sum(Qty)/sum(Total Qty)

[Anonymous]

still not clear, what exactly you want??

[Anonymous]

if it is for QTY only then try like:

=Sum(QTY)/Sum(<Total> QTY)

[Kushal_Chawda]

try below expression

num(sum(Qty)/ sum(Total <Item>Qty),'#.00%')

[Anonymous]

I put the QV Example to be clearly

Expression Pivot Table