Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
Kindly help my requirement as shown below:
I have the hierarchy Incharge1 > Incharge2 > Ename
If EndDt<StartDt then Ename SAL =0 and the same amount to be distribute to Incharge1 & Incharge2
If EndDt is NULL then SAL should distribute to Ename
My report should show like the below:
please help me.
Source Data:
EMPNO | Ename | Incharge1 | Incharge2 | SAL | StartDt | EndDt |
1 | Ename1 | Ename5 | Ename9 | 1000 | 12-May-15 | 11-May-15 |
2 | Ename2 | Ename5 | Ename9 | 2000 | 11-May-15 | 3-May-15 |
3 | Ename3 | Ename5 | Ename9 | 3000 | 10-May-15 | |
4 | Ename4 | Ename5 | Ename9 | 1000 | 9-May-15 | |
5 | Ename5 | Ename5 | 2000 | 8-May-15 | ||
6 | Ename6 | Ename5 | Ename9 | 3000 | 7-May-15 | |
7 | Ename7 | Ename10 | Ename9 | 1000 | 12-May-15 | 10-May-15 |
8 | Ename8 | Ename10 | Ename9 | 2000 | 11-May-15 | 3-May-15 |
9 | Ename9 | Ename10 | Ename3 | 3000 | 10-May-15 | |
10 | Ename10 | 4000 | 7-May-15 |
SAL column is shown 1000+2000 ,.. is for better understanding.
P
Hi,
You can manage this easily with Pivot table. Please find attached file for solution.
Regards,
Jagan.
Any help please.
I cannot see the expected report that you required.
Hi,
You can manage this easily with Pivot table. Please find attached file for solution.
Regards,
Jagan.