Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
How to write this with set analysis expression.
if(dealstate_id=8 or dealstate_id=9 or dealstate_id=33 or dealstate_id=34 or dealstate_id=71,UPPER(customerFirstName)&' '&UPPER(customerSurname) )
Thanks,
Use this in your set analysis for your expression
{<dealstate_id = {8, 9, 33, 34, 71}>}
and create a new field in the script
Upper(customerFirstName & ' ' & customerSurname) as Customer_Full_Name
and use Customer_Full_Name as your dimension
Try this:
maxstring({<dealstate_id={'8','9','33','34','71'}>}UPPER(customerFirstName)&' '&UPPER(customerSurname))
Br,
KC
You can also try this
Upper(Only({<dealstate_id = {8, 9, 33, 34, 71}>} customerFirstName & ' ' & customerSurname))
Hi Sunny ,
I have tried your its coming error .
I have used the below one in dimension . I am not sure is it the correct way of doing according to performance .of pivot table .
=if(dealstate_id=8 or dealstate_id=9 or dealstate_id=33 or dealstate_id=34 or dealstate_id=71,UPPER(salesperson)) .
it is working but my pivot table is slow that why I am trying of different set analysis.
Thanks
Use this in your set analysis for your expression
{<dealstate_id = {8, 9, 33, 34, 71}>}
and create a new field in the script
Upper(customerFirstName & ' ' & customerSurname) as Customer_Full_Name
and use Customer_Full_Name as your dimension