6 Replies Latest reply: Aug 16, 2013 3:14 AM by George Duckett RSS

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

    George Duckett

      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?