How to group columns??

[jsingh71]

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.

[Gysbert_Wassenaar]

You'll need to transform your data and create an extra field for the groups. See attached example.

[jsingh71]

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.???