Using set analysis on multiple condition for a single column

[Iwin]

Hi all,

I want to perform set analysis on multiple fields.

Eg for a  single column Revenue ,it is calculated as follows :

if(class_Category='bill_to_Rev' and CLASS_CODE = 'BILL_EQUAL_TO_REV',sum(sales amount)  else

sum({<class_Category='Sales'>}sales) -sum({<class_Category='Sales'>}costofgoods)/sum({<class_Category='Sales'>}sales) )

How can i put this in single set analysis expression?