ABC Analysis with multiple condition

[spugalen]

Here is the formula which I am using to create a list box/calculated dimension in filter pane that allows multiple select .  The formula is not giving the desired results . It should list all the segments as per the condition in the formula . It is currently listing only the first condition result(0-10% in the filter pane). Can you help me here ?

=Aggr(

    If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.1, '0-10%',

 If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.2, '10-20%',

 If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.3, '20-30%',

 If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.4, '30-40%',

 If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.5, '40-50%',

 If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.6, '50-60%',

 If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.7, '60-70%',

 If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.8, '70-80%',

 If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.9, '80-90%','Above 90 %'

))))))))),

    (Region,Country,State,Market,[Stay Week])

    )

[sunny_talwar]

Would you be able to share a sample where we can see this issue?