5 Replies Latest reply: Oct 4, 2012 9:28 AM by Miroslav Žebrák RSS

    Set analysis - Date island

    Gopinathan L

      Hi,

       

      I have created one date island table.

       

      i have one transaction table...

       

      i loaded the date island table fields like year,month,Qtr in list boxes.

       

      in transaction table i have transyear,transmonth,transQtr fields.

       

      i need to show the sum(sales) by customerwise.

       

      if i used the transyear,transmonth,transQtr in list boxes, then i can write sum(sales) in expression tab,Customer as Dimension.

       

      but i need to use the date island table fields...

       

      could anyone hepl me how to write the expression...

       

      due to restrictions i cant upload the sample file...