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]

Sum({<Salesman=>}Sales) 

In your exampel it works

[#3]

I can't see the attach

[#4]

I put your formula but, as you can see, the table contains all salesmen

thanks

[#5]

it's half correct, but if there aren't any selection I want a desagregation for each salesman; it works just when I select one of them

thanks

Cosmin

[Roop]

Last go - simply a text box over the top that can be made to look part of the table - not elegant but may work for you

[PradeepReddy]

Try the bellow expression only in table:

SUM({$<Salesman = {$(=GetFieldSelections(Salesman))}>} Sales)

[PradeepReddy]

Remove the other columns from the table and use the below expression only..

SUM({$<Salesman = {$(=GetFieldSelections(Salesman))}>} Sales)

[Anonymous]

so you want only those salesmen in the table whichhad been selected?

then the following trick will do

define the first expression like that

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

set the "suppress when value is null"

and it works !

unfortunately I cannot load up your qvw.

[#10]

yes, this is what I want

I tried to put this as a dimension where I have this option but it return to me a Error in calculation

I don't see where is this option for an expression

thanks

Cosmin

[Roop]

I like this solution a lot - The only change I would make is to change the Salesman={'A','B','C','D'} clause to Salesman= so that you do not need a list of the specific salesmen