Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to list out only the data that starts from 'AB' in my list box. how to achieve this?
Need help!
Hi,
Go to ListBox Properties --> Drill down Dimension to expression --> Write expression
If(left(PROD_HIER,2)='AB',PROD_HIER)
if(wildmatch(PROD_HIER,'AB*'),PROD_HIER)
Try like this
=if(PROD_HIER like 'AB*',PROD_HIER)
Hi,
Go to ListBox Properties --> Drill down Dimension to expression --> Write expression
If(left(PROD_HIER,2)='AB',PROD_HIER)
In liastbox-->General-->field--->Expression-->edit--->
If(Trim(left(PROD_HIER,2)='AB',PROD_HIER)