Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show the column by Calculation.

Hi

I want to show the Dept by the below condition.

my condition is show Department which have more than 60% of employee compare to Vendor. Here I attached Source file for your reference...

And please tell me if it is not possible means....

Thanks in Advance

10 Replies
alibd225
Creator
Creator

1.  =if(Vendor/Employee*100>60,Dept) in dimension

2. Check mark when Value is null

3. write expression =Vendor/Employee

4, show number tab and set show in percentage