Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
)
Would you be able to share a sample where we can see this issue?