on 2014 May 06 10:01 AM
Hi Prasad,
Please clarify this..how are you identifying the employee information who are left..is there any flag available in your tables..if yes please create two variables..
V1:count(employee) where (employee left='Y') in this i am considering employee left column ia flag which is there in my database
V2:count(employee) where (employee left='N') in this i am considering employee left column ia flag which is there in my database
Now do V2-V1..hope this may help you..
Regards,
Naveen D
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Prasad,
As per the post..i understood that you have column KPI's which is having the values Employees Joined and left are the values.. now create a variable
1.V1:count(measure) where (KPI='Employees Joined')
2.V2:count(measure) where (KPI='Employees Left')
3.V1-V2
If my understanding is wrong..can you please post some snaps related to your issue..so that i can get some clarity.
Regards,
Naveen D
Hi Prasad,
I think you want the difference between the two columns in the cross tab i.e.
"Count of Joinees" (lets say V1) and "Count of employees left the organisation" (lets say V2)
For achieving this you can do:
1. Create a variable V1 (as measure) for "Count of Joinees" as you have already used in your cross tab (1st Column), just create a variable for it.
2. Create another variable V2 (as measure) for "Count of employees left the organisation" as you have already used in your cross tab (2nd column) just create a variable for it.
3. Add a column next to "SUM" insert the formula =[V1]-[V2]
I think this should work just try it.
Thanks,
Shardendu Pandey
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Prasad,
Creat Variable
=[employees Joined] - [employees left organization]
and insert a column on right place the variable in empty column
Add the variable to cross tab
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Mahi ,
How can we create =[employees Joined] - [employees left organization] ?
Both are dimensions and we have only one measure called Employee count.
employees joined =500
Employees left=50
Total =500-50=450
The measure column employee count holds 500 and 50 for different dimensions.
Regards
Prasad Ambati
Hi Mahi,
Create A variable
Var_Diff=([Employee count]Where([EMP Status]="Count of Joinees")) - ([Employee count]Where([EMP Status]="Count of employees left the organization"))
[Employee count] is A measure and [EMP Status] is A dimension where you placed dimension in cross tab upper header. I dont know the dimension name that is the the reason I named it as [EMP Status]. place your dimension name here
Thanks,
G Sampath Kumar
User | Count |
---|---|
69 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.