Multiple if condition to be used in Multi box

[#1]

I have a multiple if conditions that is used as a bucket and I should use the same condition to display in a MUlTIBOX.    

     In the sample document there is Growth, Status Quo, potential , decline in the if condition but when the drop down is selected in the multibox I need to get the four that is mentioned above

   By selecting the multibox element I should get it in the table

example if i select growth in the multi box then it should display only growth object that is present in the table

[tresesco · Accepted solution]

You could probably simplify your sales expression like,  ( *>0,Sum(A)/Sum(B))

Take a variable say,

vSum -> if( *>0,Sum(A)/Sum(B))

Then multibox expression like:

=Aggr(

IF($(vSum)>0.2,'Growth',

IF($(vSum)>=-0.2,'Status Quo',

IF($(vSum)<-0.2,'Decline'

))),

year

)

[#3]

If I do have multiple filters and things like Year are many then it can be solved by using the same expression