I want to display a table with certain order numbers in it.
I would like to do this using de If function.
Are made up through the following format :
I would like the table only to show the order containing IPMOR.
Can anybody help me with this ?
I suppose you want to use a calculated dimension. Lets call the field "Account Name" and create the dim like this:
=if( Left([Account Name],5) = 'IPMOR', [Account Name])
Try the below code
=If( Match([Account Name],Left([Account Name],5) = 'IPMOR') , [Account Name] )
To check IPMOR only in the expression or table.
Retrieving data ...