Skip to main content
Marching toward a simplified navigation! READ ON
Showing results for 
Search instead for 
Did you mean: 
Partner - Creator
Partner - Creator

Using set analysis on multiple condition for a single column

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?

Labels (3)
0 Replies