Set analysis

[suvechha_b]

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,

[jyothish8807]

Try this:

maxstring({<dealstate_id={'8','9','33','34','71'}>}UPPER(customerFirstName)&' '&UPPER(customerSurname))

Br,

KC

[sunny_talwar]

You can also try this

Upper(Only({<dealstate_id = {8, 9, 33, 34, 71}>} customerFirstName & ' ' & customerSurname))

[suvechha_b]

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

[sunny_talwar · Accepted solution]

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