problem with listbox selection

[#1]

hi,

i have table which i have linked to a listbox. if i dont select anything from the listbox then all the data are accurate. however if i select a division from the list box, in the 3rd column the sum of all division shows instead of showing the sum only for that division. if i clear the selection the relavant sum shows up correct. so i believe i am missing something.

attaching the file for refrence.

[sunny_talwar · Accepted solution]

Please check if this is what you were trying to accomplish. PFA

Best,

S

[rwunderlich]

A good way to debug this is to put each of the components into separate columns. You'll see that the sum(Resource) is the same for all Divisions except ADN. So when you filter to a Division it's 1/1*Resource and you get the same answer.

I think what you want is to consider all the Divisions in your TOTAL divisor. Add a set modifier to ignore DIvision selections.

=Sum([Time to complete])/Sum({<Division=>}Total [Time to complete])*Sum(Resource)

-Rob

http://masterssummit.com

http://robwunderlich.com

[#4]

thanks a ton buddy...it worked