2 Replies Latest reply: Mar 27, 2012 5:29 PM by Josh Duenyas RSS

    Question re Calculated DIMENSION

    Josh Duenyas

      Hi All

      I have a table like the following:

       

      CustomerCustomer CreateDateOrder CreateDateOrder Amount
      A1/1/111/1/12                       125.00
      B1/1/121/15/12                       352.00
      A1/1/112/1/12                         35.00
      C2/1/122/15/12                       486.00
      A1/1/112/15/12                       651.00
      B1/1/123/1/12                       268.00
      D2/1/123/1/12                       566.00
      E2/1/123/15/12                       321.00
      D2/1/123/15/12                       951.00
      F3/15/123/15/12                       423.00

       

      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.

       

      Any ideas?

       

      Thanks

       

      Josh