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?