Filter Pane shows only last option after selection. Other option get disappeared.

[Vaibhav_M]

Hi Team,

Kindly find the code below:

=If(aggr($(vSKUOrder%_New), MySQL_Customer, MySQL_MonthYearNo) >= 0.00 and aggr($(vSKUOrder%_New), MySQL_Customer, MySQL_MonthYearNo) <= 0.35, '0-35%',
If(aggr($(vSKUOrder%_New), MySQL_Customer, MySQL_MonthYearNo) > 0.35 and aggr($(vSKUOrder%_New), MySQL_Customer, MySQL_MonthYearNo) <= 0.60, '36-60%',
If(aggr($(vSKUOrder%_New), MySQL_Customer, MySQL_MonthYearNo) >= 0.60 and aggr($(vSKUOrder%_New), MySQL_Customer, MySQL_MonthYearNo) <= 0.80, '61-80%', '81-100%'
)
)
)

Currently have created a bucket i.e. 0-35,36-60,61-80,81-100. This buckets are used as a filter. The problem i.e. when i select  any filter eg. 0-35 it should show other remaining option too but it shows 81-100 only. May be coz of the if else condition. Kindly help me out in this ASAP.