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
