Two dates as single date

[Abhi999]

Hi, could some one help on below scenario .

I dimension I have two rows orders received based on received date and delivered orders based on delivery date .

But in pivot table I need show like below

Ores type.     Count of orders

Received.      Count of order based on received date

Delivered.      Count of orders based on delivered date

[jwjackso]

Try Henric's Canonical Date 

You will have date types, received and delivered.  In the pivot table you you would have order type, canonical date, count(orders), count({<DateType={'received'>} orders),count({<DateType={'delivered'}>}

[Abhi999]

Two count statement in same exp not working.

[edwin]

I would prefer to use a single calendar, this way you can use multiple date types in the same expression.  as an alternative to the Canonical Calendar post, you can join the high level date fields into the lowest granular level.  that way you have all your dates in one table - then create a bridge to a single calendar.  this way for any date, you can determine how many units were ordered and shipped.  in your case how many were ordered and delivered on specific date

[Brett_Bleess]

@Abhi999 if Edwin's post got you what you needed, we would appreciate it if you closed out the thread by using the Accept as Solution button on the post to mark that as the solution.  If you require further assistance leave an update, and if you did something different, you can post that and then use the button to mark that post too.

Regards,
Brett