Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use =if(Vendor/Employee*100>60,Dept) in dimension
and check suppress when value is null
and
ji that is not working
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.
please see the attached
what will be the expected output?
PFA. Hope it will help.
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
PFA
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...