Summing up excluded values as Other

[VivenReddy]

I have attached a sample qvw with some fruit sales. It has a list box and a straight table showing sales of each fruit.

If no fruit have been selected from the list box then sales of all fruit should be displayed in the straight table. When fruit selections have been made then those selected fruit should be in the straight table AS WELL AS combining all other fruit sales (excluded fruit) into 'Other'. 

[VivenReddy]

Just when I think Qlikview is so limited and then I see the great work you guys do on these forums.

Thanks Sunny. I'm a big fan. 

[VivenReddy]

I am struggling with the getting the expression for the calculated dimension for Volume$ where row = Others. How do i get a single value as apposed to 4 values in the example below. Attached is the qvw file.