Pivot table with 2 expressions using different dimensions displayed as one row

[Anonymous]

I have some data about an engineer service call. The call has a time when the customer rang (CallInDate), and a time when the engineer attended(CallCDate) and the type of call.

I have 2 time dimensions for the call. One linked with the CallInDate and one linked with the CallCDate.

I want a table that has month/year in the first column, number of calls taken (CallInDate) as an expression and number of calls completed (CallCDate) in the month.

Obviously I can easily do one or the other by using the appropriate dimension and doing a simple Count(), but how can I get both in the same table?

[#2]

George,

see the attached example.

I hope it´s showing what you are looking for.

Good luck!

Rainer

[Anonymous]

Hi thanks for the example, the table structure isn't quite what I have though.

I have a fact table, with many different things, one of them is the call data.

They key difference between your example and my data is that the call data, with CallInDate and CallCDate is that there is only one row, containing both dates in different fields.

[#4]

George,

please provide some example data (example.qvw).

Thank you!

Rainer

[Anonymous]

Hi Rainer,

See attached

Thanks.

[#6]

Hi George,

I´m not exactly sure what your starting point is.

I guess the table CallData.

See the attached file.

It´s nearly the same as the first one.

Good luck!

Rainer

[Anonymous]

Sorry, yes, the table CallData is the starting point.

Thanks for the help. Is the only way going to be changing my table structure (i.e. doing a resitent as you have)?

The real tables are quite a bit more complex but if this is the only way then I'll have to figure it out.