4 Replies Latest reply: Feb 17, 2010 4:40 PM by Aaron Witt RSS

    Data comparaison from a starting Date

    Jean-Jacques Jesua


      Dear community

      As I'm not very comfortable with the Set Analysis, I call the community for Help on this case.


      I have a big table with 3 fields :
      - Store
      - Monthname ( Jan08, Feb08 , ...., Jan10)
      - Revenu

      I have also a lookup table with 2 fields :
      - Store
      - StartMonth which is a Monthname where a test begin
      - Dummy = 1

      This Table is a subset of Store (not all store are testing)


      I want to display in chart (straigt-table) some various calculation by store or by StartMonth :

      - Cumulate revenu for the next 3 month after StartMonth
      If StartMonth = Jan09 , i need the cumulation of Feb09, Mar09 & Apr09

      - Cumulate revenu for the last 3 month before StartMonth
      If StartMonth = Jan09 , i need the cumulation of Oct08, Nov08 & Dec09

      - Cumulate revenu for the last 3 month after StartMonth but for previous year
      If StartMonth = Jan09 , i need the cumulation of Feb08, Mar08 & Apr08


      I need also to compare this figures to another subset of store for example the not testing store (Dummy = 1).



      Many thanks for your Help

      Jean-Jacques