Need to arrange a filter drop down

[AbiramiN]

Hi, I want to bring the FX ADj Working Forecast to last place, all the other in same sequence. 

And I tried dual, match, wild match and using variables, I am getting the same order as in Pic.

Please help me out with this.

[VBD]

Hello, can you send the expressions that you tried ?

It should be work 

[VBD]

best way to do that is in the script with a dual : 
load dual(MYFIELD,id) as MYFIELD inline
[MYFIELD, id
ACTUAL,1
FX ADJ WORKING FC,7
FY24 BUDGET,2
FY24 FC1,3
FY24 FC2,4
FY24 FC3,5
WORKING FORECAST,6
];

But it should be work with an if in your sorting expressions :

if(MYFIELD = 'ACTUAL',1,

if(MYFIELD = 'FY24 BUDGET',2,

if(MYFIELD = 'FY24 FC1',3,

    if(MYFIELD = 'FY24 FC2',4,

        if(MYFIELD = 'FY24 FC3',5,

                if(MYFIELD = 'WORKING FORECAST',6,

                if(MYFIELD = 'FX ADJ WORKING FC',7)))))))

    

regards

[AbiramiN]

1. Dual(
  [Var Analysis Baseline 1],
  Index(
    'ACTUAL|FY24 BUDGET|FY24 FC1|FY24 FC2|FY24 FC3|FY24 FC4|FY24 FC4 FX|Working Forecast|FX Adj Working Forecast',
    [Var Analysis Baseline 1]
  )
)

2.IF([Var Analysis Baseline 1]='ACTUAL',1,
IF([Var Analysis Baseline 1]='FY24 BUDGET',2,
IF([Var Analysis Baseline 1]='FY24 FC1',3,
IF([Var Analysis Baseline 1]='FY24 FC2',4,
IF([Var Analysis Baseline 1]='FY24 FC3',5,
IF([Var Analysis Baseline 1]='FY24 FC4',6,
IF([Var Analysis Baseline 1]='FY24 FC4 FX',7,
IF([Var Analysis Baseline 1]='Working Forecast',8,
IF([Var Analysis Baseline 1]='FX Adj Working Forecast',9)))))))))

[AbiramiN]

Hi, Thank you

But those approaches are not working for me.

[VBD]

can you send a screen of your filter panel properties ?

[AbiramiN]

Sure,

[VBD]

Is that an extension ? can you try in the "true" filter panel 

[AbiramiN]

Hi, i will try once. Thank you