always show totals no matter which warehouse is chosen

[#1]

Hi

I want to display total stock on hand even if a specific warehouse is chosen.  Let me illustrate.

In the table below I have 2 items, A & B with quantity on hand for each location.  I want to create a chart (straight table) for total stock on hand , so that if i select a specific warehouse , it must still give me total stock hand.

So, if i have a warehouse list box, and i select warehouse 1, the value must still show me stock on hand for A= 200 and for B=1,100)

ITEMNO	Warehouse	Stock on Hand
A	1	30
A	2	80
A	3	90
B	1	500
B	2	200
B	3	400

How do i create this formula.

Please help

Thank you

kind regards

Nayan

[jagan · Accepted solution]

Hi,

Try this expression

=Sum({<Warehouse=>} StockOnHand)

The above expression ignore Warehouse selection.

Regards,

Jagan.

[#3]

Hi Jagan

Thank you .  It worked.  Much appreciated.

kind regards

Nayan