Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use Product as your dimension and three expressions:
First 12 Months: sum(if(sales_date>=release_date and sales_date<addyears(release_date,1),sales))
2nd 12 Months: sum(if(sales_date>=addyears(release_date,1) and sales_date<addyears(release_date,2),sales))
3rd 12 Months: sum(if(sales_date>=addyears(release_date,2) and sales_date<addyears(release_date,3),sales))
Change sales_date, release_date and sales to whatever is appropriate for your document.
Use Product as your dimension and three expressions:
First 12 Months: sum(if(sales_date>=release_date and sales_date<addyears(release_date,1),sales))
2nd 12 Months: sum(if(sales_date>=addyears(release_date,1) and sales_date<addyears(release_date,2),sales))
3rd 12 Months: sum(if(sales_date>=addyears(release_date,2) and sales_date<addyears(release_date,3),sales))
Change sales_date, release_date and sales to whatever is appropriate for your document.
AWESOME!!! Works GREAT THANKS!!!