Show the column by Calculation.

[#1]

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

[alibd225]

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

and check suppress when value is null

and

[#3]

ji that is not working

[#4]

In the expression tab - on the column you need, check the Conditional check box so it's not greyed out, then enter your expression for Dept/Vendor as required.

[alibd225]

please see the attached

[Kushal_Chawda]

what will be the expected output?

[senpradip007]

PFA. Hope it will help.

[#8]

This is my expected output

Dept      Employee

Dept1      73%

Dept2      82%

Dept3       71%

The percentage value may be wrong, But I need the output like as above.

And one more thing I don't 've rights to open qvw files so pls reply me an expression . That is enough to me

[senpradip007]

PFA

[#10]

Ji am using personal edition only I can't open this qvw file so can you please text me what exactly you did on that qvw...