This content has been marked as final. Show 2 replies
I have a table like the following:
|Customer||Customer CreateDate||Order CreateDate||Order Amount|
I wish to show total of orders by selecting Order Date but only of the customers whose create date is equal or greater then the minimum order date.
So if selecting order date as greater than or equal Feb (2/1/12), Customer A and B will not show because they were create prior to the date selected. Likewise if selecting order dates greater than or equal Mar (3/1/12) only Customer F will show.
I want the Customer to be in the DIMENSION list and the total calcultaed in the Expression.
In other words, I wish to show in my table only the NEW Customers who palced an order in the selected range of the order dates.
I tried to set the dimension to be:
If([Customer CreateDate] >= [Order CreateDate],Customer) but that did not work.