Set Analysis using variable

[matancha]

Hello all.

I'm develop an OOR (Open Order Report), and I have a problem....

My Background table (that loaded on script):

Open Orders

Warhouses Balance

I want to show a table with all the open orders details, and the corresponding current delivery warhouse balance.
On Open Orders table I have a fields that contain the delivery wrhs:

OpenOrders.DeliveryWarehouseName

On Warhouses Balance, field that contain the name of the warehouse.

Warehouse#

My idea was to define a variables that contain the OpenOrders.DeliveryWarhouseName:

vDeliveryWrhsName = OpenOrders.DeliveryWarehouseName

and by Set Analysis to wrote somthing like:

Sum( {< Warehouse# = {'$(vDeliveryWrhsName)' >} WarehousesBalance.Balance ).

and it's not working for me...

My problem is how to declare the variable (maybe more than 1?), and how to use them in the chart (straight or pivot tables).

sopry for my poor english,

hope that is clear.

Thanks in advance -

Matan.

[matancha]

Hi Vipin -

Currently - I don't think I can attach the original file (its a big file, with a lot of commercial data...)

Matan.

[vipin_mishra479]

make some related example file.

[matancha]

Hi Vipin.

I attached a file with an example.

Please look at the "Delivery Wrhs Qty Balance" - (yellow chart column) .

How can I write it with Set Analysis?

Please note that currently there is 1 DB (qob), and in reality there is more (if this matter),

Thanks (again...) for your help -

Matan.