Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data in following format:
Year | Quarter | Month | Week | Schedule Hrs | Worked Hours | Absent Hours | Overtime | Planned | Holiday | Vacation | Unplanned | Sick | Jury | Bereavement | Plant | Department | Job | S1 | S2 | S3 |
2010 | 1 | 1 | Week 01 | 200 | 190 | 10 | 20 | 6 | 4 | 2 | 4 | 1 | 2 | 1 | Flint Assembly | 01023-T-0DIE | 01011-1001 | 4 | 2 | 4 |
2010 | 1 | 1 | Week 02 | 150 | 131 | 19 | 38 | 10 | 3 | 7 | 9 | 2 | 5 | 2 | Flint Assembly | 01023-T-0DIE | 01011-1001 | 8 | 3 | 8 |
2010 | 1 | 1 | Week 03 | 175 | 136 | 39 | 76 | 20 | 6 | 14 | 19 | 5 | 7 | 7 | Flint Assembly | 01023-T-0DIE | 01011-1001 | 16 | 11 | 12 |
2010 | 1 | 1 | Week 04 | 190 | 178 | 12 | 23 | 7 | 2 | 5 | 5 | 1 | 1 | 3 | Flint Assembly | 01023-T-0DIE | 01011-1001 | 6 | 2 | 4 |
Now I want
1) "Planned" and "Unplanned" comes under Leave. for example:
Leave |
---|
Planned |
Unplanned |
2) "Holiday" and "Vacation" comes under "Planned".
3) "Sick", "Jury" and "Bereavement" comes under "Unplanned".
4)"S1","S2" and "S3" comes under "Shift".
How can I achieve this??
This type of grouping I want in my .qvw file when I create list boxes I want Leave,Planned,Unplanned and Shift Fields.
You'll need to transform your data and create an extra field for the groups. See attached example.
Hi Gysbert,
Thanks for the solution.
You make a Group which contains:
Group
------------
Planned
Unplanned
Shift
Total
Work
But I want 4 groups like
Leave Planned Unplanned Shift
------------ --------------- ------------------- ---------------
Planned Holiday Sick S1
Unplanned Vacation Jury S2
Bereavement S3
Please help how I get this.???