Incorrect Sum from Measure

[Anonymous]

I have a measure that shows us the weight of products sold per order, but when used in pivot table, the total sum is shown incorrectly.  Has anyone experienced this issue previously?  If so, what is a possible solution so that the correct total weight is shown?  Below is expression I am using:

SUM(aggr(Sum(distinct (weight_base / 1000000) * qty_base), order_product_inventory_id))

Thanks in advance for help.

[marcus_sommer]

Maybe there are further dimensions within the pivot which aren't covered within the aggr().

- Marcus

[balabhaskarqlik]

May be:

=SUM(aggr(Sum(weight_base / 1000000) * only(qty_base), order_product_inventory_id,Field2))