I want to be able to see how new products do every months months from its release date. For example, if we have a product that is release on 06/15/2008 I want to be able to see the sales from 07/01/2008 - 06/30/2009, then from 07/01/2009 - 06/30/2010. Each product has a unique release date.
I want the columns of the report to look like this
First 12 months 2nd 12 months 3rd 12 months
Product A 10,000 15,025 26,780
Product B 36,999 40,234 53,500
I am using the personal edition so I cannot open any QVS file so please just send suggestion in reply.
I really am desperate......any help is appreciated