2 Replies Latest reply: Mar 1, 2013 3:54 PM by Lance James RSS

    Sales in 12 Month Increments

      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