i want to create a dimension using "If" "And"
the dimension needs to answer two criteria
itemid starts with 5c
if both conditions are true than i want to make a dimension called "valve"
Try Like this,
=if(prodpoolid=20 and wildMatch(itemid,'5c*'),valve)
Retrieving data ...