hide unselected items

[#1]

Hi all,

i have a straight table something like this:

Salesman           All Sales ({Salesman={<'A','B','C','D'}>}         sales (only for selected salesman)

A                              40                                                                 10

B                              40                                                                 10

C                              40                                                                 10

D                              40                                                                 10

when I select a salesman, the table shows all salesmen thanks to the formula for all sales, but with 0 value for unselected items

how can I fix this?

Thanks

Cosmin

[Anonymous]

you only change your first expression to :

=  if (Sum(Sales)=0,0,Sum({<Salesman={'A','B','C','D'}>}Sales))

and under dimension you select the "suppress when value is null"

thats all.

[Anonymous]

thats okay, as it works as well

[#4]

it's close but look in that square..there have to be 40 (A+B+C+D)

thanks

[Anonymous]

i donot understand why you want 40 for salesman B

but here is the solution, but you see 40 for every salesman

= if (Sum(Sales)=0,0,Sum(total{ <Salesman=>}Sales))

[#6]

thanks a very useful solution

do you know, for example, if I have one more dimension, like Region what I have to add in set analysis to obtain Sales for all salesmen but split in regions?

Cosmin

[#7]

I solved with = if(Sum(Sales)=0,0,Sum(total <Region> {<Salesman=>} Sales))

thanks Rudolf and all guys for help

Cosmin