Intersection of two dimensions

[ilyas_coban]

Hi all,

I have data like this:

XXX.ID	XXX.Start	XXX.End
1	01/01/2000 01:25	01/01/2000 02:25
2	01/01/2000 00:12	01/01/2000 01:12
3	01/01/2000 12:34	01/01/2000 14:34
4	01/01/2000 04:00	01/01/2000 05:00

YYY.ID	YYY.Start	YYY.End
5	01/01/2000 06:43	01/01/2000 09:25
6	01/01/2000 03:33	01/01/2000 09:25
3	01/01/2000 18:34	01/01/2000 19:34
4	01/01/2000 13:00	01/01/2000 15:30
4	02/01/2000 13:00	02/01/2000 15:30

...

And i want to calculate total work hours of person that works at both XXX and YYY departments for each day separately. YYY.ID and XXX.ID are not connected. Is there any way to do this without changing script? Like using calculated dimension or set analysis. I think an intersection like function can solve my problem but i couldn't find anything.

My result should look like this:

ID/Date	01/01/2000	02/01/2000
3	03:00	-
4	03:30	02:30

Best regards,

İlyas

[alexandros17 · Accepted solution]

In dimension write If(XXX.Id=YYY.Id, XXX.Id, null())

then suppress Exclude null values checkbox.

In the expression simply sum your values from both tables: sum(valTable1)+sum(ValTable2)

where val ... are your hours

[sujeetsingh]

Ales is right you can use this as calculated diemsion.

[ilyas_coban]

Thanks.