Sum of items that do not belong to the selected object

[#1]

I have a table called warehouses with their sku.

If you selected a warehouse, it shows me the sum of all sku's in this warehouse. How do the sum of all sku that not are in selected warehouse?

[MayilVahanan]

HI

Are you want to exclude the selections?

Sum({1}Sku)

or

Are you expecting the remaining values from the selection?

=Sum({1}Sku) - Sum(Sku)

Its give the remaining sum of all sku that are not selected.

Hope it helps

[Anonymous]

In general, for the excluded, you can use
sum({1-$} SKU)

In your case, probably this:
sum({<Warehouse=E(Warehouse)>} SKU)

Regards,
Michael

[#4]

Thanks, i try to use =Sum({1}Sku) - Sum(Sku), but the graphic come with others sku's of the others warehouses.

I need when i select for example 'WAREHOUSE1', show only  units of every sku of this warehouse, and show sum of units for this skus if exist in others warehouses.

sorry for my english, just speak spanish.... but i try to speak and write in english.

[CELAMBARASAN]

May be something like

Sum({<Warehouse=,Sku=P(Sku)>} Units)

Can you attach a sample if it didn't work for you?