you could probably add an "All Countries" to the list, but as far as I know not from within the box.
I am just thinking of kind of a linkage table betwenn your dimension values used for the list box and the country dimension used in calculations. Maybe I just miss a much easier solution right now.
And if you add "All Countries", you could also add "No Countries" (with no links in linkage table). That would be consistent with the usage model.
P.S. How have you managed to use Always One Value Selected in a Multi box? Haven't found that option so far.
"P.S. How have you managed to use Always One Value Selected in a Multi box? Haven't found that option so far."
swuehl, on QV10 just select on value on the field of the multibox and then go to the Presentation tab and tick Always One Selected Value.
Thanks BlackRocks, your solution would work but it means duplicating my main facts table.
Is there another way of doing this with a variable and an expression on the multibox for example? Maybe with set analysis too?