Hello,
I like to create a crosstab query that will allow me to show the future month in the report.
example: In Apr 2012 report. it will show below.
Target Product - May, Jun, Jul, Aug, Sep, Oct, Nov, Dec, Jan, Feb, Mar, Apr
Product A - 10,20,0,10,10,20,11,10,10,10,11,20
In May 2012
Target Product - Jun, Jul, Aug, Sep, Oct, Nov, Dec, Jan, Feb, Mar, Apr, May
Product A - 20,0,10,10,20,11,10,10,10,11,20,10
Anyway to do a moving months in a Crosstab Query?
Many Thanks
Ray