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

[senpradip007]

can you upload an sample apps?

[Anonymous]

you should define the whole data range using "1" to override the selection of salesman (and everything else)

sum({1<Salesman={'A','B','C','D'}>}Sales

[#4]

I attached

thanks

[#5]

in reality I have more dimensions and I can't do this

thanks

[Anonymous]

It "works as designed".  What is the intended behavior?

[#7]

see the attach from the top

when I select just one Salesman I want to see just one on straight table

Thank you

[Anonymous]

In this case your expression for all sales should be:

sum(all Sales)

It's going to ignore all selections.

[Roop]

I have attached a new example. I have detached the Salesman1 value from the table and so can be used to select values. Obviously you would not show the "Salesman" listbox in my example.

So your sales value is now just sum(Sales) and the other value is filtered by the value in Salesman1

Hope it helps

[Anonymous]

One more option

sum({1} total Sales)

It maybe useful if you want not to ignore some selections.  In this case you'll add fields "not to ignore" in set