This is a migrated thread and some comments may be shown as answers.

help with cross tab

1 Answer 35 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Chris
Top achievements
Rank 1
Chris asked on 02 Feb 2017, 01:49 PM

Hello,

 

I currently have a cross tab as shown in the attachment. I would like to have something with the date as the column heading but Duty Hours, Duty Start Duty end as rows ie:

                    01 Jan      02 Jan    03 Jan

Duty Hours 5.58              6.33       5.00

Duty Start 07:30            06:00      07:00

Duty End 13:05             12:20       12:00

 

is this possible?

1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 06 Feb 2017, 03:41 PM
Hello Chris,

If the data structure is like:
Date,Duty,Val
jan1,hours,5
jan1,start,7
jan1,end,19
jan2,hours,8
jan2,start,10
jan2,end,20

You can use the Date field as Column Groups, the Duty field as Row Groups and the Val field as Detail Values. This will create dynamic row and column groups based on the values of the fields. The attached image illustrates the suggested settings.

Regards,
Stef
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Chris
Top achievements
Rank 1
Answers by
Stef
Telerik team
Share this question
or