Defining a Calendar

[#1]

Dear All,

I have multiple calendars in my data. One is the registration date, another is the Energization date. The issue I have is that i want to display the number of registrations and energizations in a single month year in a table. Since these are different dimensions in my data model i am unable to do so. I want a table in the following format:

Month Year      Registered Cases     Energized Cases

jan 2015          xyz                             abc

feb 2015          djfh                               dkj

I tried making a pivot table using the MonthName field that i have that relates to all dates. Then i added the followng expression fro registred cases but it is not working:dsf

count({<MonthName=[Registration Month]>}Distinct  [Case ID])

Similarly for Energized i replaced the Registration month with energized month.

Please help!!

[Anonymous]

Hi

You need to tag the different tables in the script. In my case I have two tables, one with shipments and shipment dates and one with orders and order dates. In each table I create a new row in Orders like this 'Orders' As Transtype and in Shipments 'Shipments' As Transtype. I then rename the datefield in each table to Dates and concatenate the tables. not sure if this will work in your case but this is just to show how I set it up.

I can then use the same date but still seperate the source based on the Transtype field.

In a table it would look like this using two expressions

Count( {$<TransType= {'Shipments'} >}DISTINCT OrderID )  and

Count( {$<TransType= {'Orders'} >}DISTINCT OrderID )