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.