Create a Smartlist with different columns based on a certain User Category Value. Cannot find = in Mathematical function or IF calculation to use a search criteria.
If I'm following you correctly, you would have to set-up multiple columns (calculated fields) per analysis.
If you have a User Category = Style with values Long Sleeve and Short Sleeve, you would need Calculated field "UC1Short" and "UC1Long" (any name). Then establish the Case statement for each:
WHEN GPUserCategoryField = "Long Sleeve" THEN "Yes"
WHEN GPUserCategoryField = "Short Sleeve" THEN "Yes"
This would return a data set like:
ITEM UC1Long UC1Short
ShortTShirt No Yes
LongTShirt Yes No
Thanks Mike. You helped me a lot. Only one more question: which Field Description I have to use in "WHEN"?? From SmartList Builder or the SQL Table Description???
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13