Can You use a calculated measure in set analysis

[MPH]

Is this legal statement

Num({$<PRODUCT_TYPE-="*spares","*spare"}>} sum(BILLING_SHIP_PROFIT)/sum(BILLING_AMT),'#,##0%')

[Steven_Haught]

I would try this.

Num(
(Sum({$<PRODUCT_TYPE-={"*spares","*spare"}>}BILLING_SHIP_PROFIT)
/
sum(BILLING_AMT))
,'#,##0%')

[MPH]

It Works! Thank You for response!

[Steven_Haught]

Great! If appropriate, please mark the above as the answer! 

[Swetha4]

Hi Steven 

Similar question I want to perform set analysis will this work

sum( {<product name ='car',Location ='America'>}Sum(sales)*avg(purchase Price))