Set analysis with aggregation

[Anonymous]

Hi Qlik Community,

I am currently facing a problem of calculating a measure while ignoring certain fields.

Of course, it can be solved by utilizing set analysis like below

Sum({$<[Customer ID]=,[Customer Name]=>} [Weight])

However due to some reason the database is a link-up of two tables, in which when I calculated Total [weight],

it has to be calculated as

Sum(aggr(Only([Weight]), [Shipment ID],[Batch ID]))

When I tried to combine two functions like

Sum({$<[Customer ID]=,[Customer Name]=>}aggr(Only([Weight]), [Shipment ID],[Batch ID]))

it failed to give correct answer.

Can anybody suggest a correct solution?

BRgds,

Keith