Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
)
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
)
If I do have multiple filters and things like Year are many then it can be solved by using the same expression