Double step in set analysis

[#1]

Hello to everyone who is going to read my new question.

Let us imagine that I have 4 kind of store shelves : A - B - C - D and many customers.

In one tab, I would like to show the total amount paid by each customers in shelves A and C.

That's what I've written so :  =sum({<[Shelve]={'A','C'}>}count_total)

But, when I select one shelve (for example A), the graph doesn't move. It still shows me the total amount for the two shelves (logical).

Is it possible to show :

     - total amount in shelves A and C when I don't select anaything ;

     - total amount in the shelve I select when I choose A or C ?

Thanks for your help.

[MayilVahanan]

Hi

     You can use if condition like this,

     =if(match(getfieldSelections(año),2009,2011),sum({<año = {$(=getfieldSelections(año))}>}instalacion), Sum({<año = {2009,2011}>}instalacion))

Hope it helps

[mikecrengland · Accepted solution]

Put a ' * ' before the ' = '

=sum({<[Shelve] * ={'A','C'}>}count_total)