Hi all,
I've made a Calculated Dimension using the below code and the intention is to use this as a drop down filter.
If((Aggr(Rank(Sum(${<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) < 6, 'Top 05',
If((Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) > 6 and (Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) <= 10, 'Top 05-10',
If((Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) > 10 and (Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) <= 15, 'Top 10-15',
If((Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) > 15 and (Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) <= 20, 'Top 15-20',
If((Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) > 20 and (Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) <= 25, 'Top 20-25',
If((Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) > 25 and (Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) <= 30, 'Top 25-30'))))))
While the logic works fine and i'm able to use this as a filter, the problem is every time is select any drop down option apart form 'Top 05', the selections are done correctly, however it shows 'Top 05' in the filter options.
Ex : If i select 'Top 10-15' the selections made are correct & logical, but the drop down shows the selected field as 'Top 05'.