I want a value not affected by selection

[#1]

Hi

I want to create a formula (on the front end) where the value (total) is not affected by selection.

So lets say for example:   I have a back orders on an item (say Item A) from the following customers below:

Item A:

Customer                Quantity on Back Order

    A                                        30

    B                                        20

    C                                        50    

TOTAL                                    100

In the list box if i select customer A, I want to still want to show a back order (Total) of  100.

kind regards

Nayan

[#2]

Hi Karthik

I've screenshot your model.   however, the value for Item A should be 100 and not 230.

kind regards

Nayan

[#3]

Hi,

Please check the attached file. I think this is what you are looking for.

Take care,

Rok

[#4]

Hi Mohit

Thank you .  Your formula specifically chooses Customer A.  However, in my original model i have over 2000 customers.  How will the formula work then.

kind regards

Nayan

[#5]

Hi All

Basically, what i want to see what is the total back order of an item no matter what customer  whether one or more than one) is selected .

So in my example above, if i select Item A , and if i select Customer A, or B or C, or all 3 customers or any 2 cusotmers , it must give a value of 100

kind regards

Nayan

[#6]

Hi Rokskrinjar

Thank you , howwever thats not the answer im looking for .  See my last post, im looking for a total quantity on back order of an item selected, no matter what customer (s) has been selected.

kind regards

Nayan 

[#7 · Accepted solution]

Hi,

So the total row in the table gives you the total backorder for any item regardles of customer. Maybe you don't even want to show customers in this table? I've created the second table, that only shows back orders by items.

Best!

[#8]

Hi Rokskrinjar

Thank you, it works.  I see the table you have its a pivot table.  Will this only work if it is a pivot table.

kind regards

Nayan

[#9]

The second table could also be a straight table. The result would be the same.

The first table would need some tweaking.

[#10]

Hi Rokskrinjar

Thank you for all your help.  Much appreciated.

kind regards

Nayan

[#11]

Hi Mohit

i got the correct answer from Rokskrinjar. 

Thank you for your assistance.  Much appreciated.

kind regards

Nayan