en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
SO  
#1 Posted : Thursday, August 27, 2015 7:38:55 AM(UTC)
SO
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/19/2014(UTC)
Posts: 72

I have a crosstab with all orders and quantity of each product type.

All orders have "order date" and "invoice date".

I want to show only orders where difference between "order date" and "invoice date" <= 30 days. How can I solve this?
Ole  
#2 Posted : Monday, August 31, 2015 6:42:34 AM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 320

I can only see this done if you create two measures based on those two time dimensions. This you will have to do as an expansion to your Data Warehouse. You will then be able to make calculations upon the measures. The time measures will need to be included in the crosstabs in the TARGIT client to make the calculations, but otherwise they may be hidden.
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
SO  
#3 Posted : Monday, August 31, 2015 7:20:53 AM(UTC)
SO
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/19/2014(UTC)
Posts: 72

Originally Posted by: Ole Go to Quoted Post
I can only see this done if you create two measures based on those two time dimensions. This you will have to do as an expansion to your Data Warehouse. You will then be able to make calculations upon the measures. The time measures will need to be included in the crosstabs in the TARGIT client to make the calculations, but otherwise they may be hidden.


Thanks for the help.
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error