I am currently using Discoverer 4.1 and I can run reports that display all of these different types of sales.
I have a Cross tab and I want 5 columns showing the Sales below.
2013 Month Sales, 2013 YTD Sales, 2012 Month Sales, 2012 YTD Sales, and 2012 Total Sales
I installed Discoverer 188.8.131.52 and I copied my reports over, but no sales show up.
Does the NEW Discoverer need different calculations or conditions?
I couldn't find anything on it.
I have all of these checked.
Short Date Range = '2013' AND Month = 'FEBRUARY'
2012 Total = CASE WHEN "Year" = '2012' THEN Net Selling ELSE 0 END
2012 YTD = CASE WHEN YearMon IN ('201201', ‘201202’) THEN Net Selling ELSE 0 END
2012 Mth = CASE WHEN YearMon = '201202' THEN Net Selling ELSE 0 END
2013 YTD = CASE WHEN YearMon IN ('201301', ‘201302’) THEN Net Selling ELSE 0 END
2013 Mth = CASE WHEN YearMon = '201302' THEN Net Selling ELSE 0 END
Keep in mind, these conditions and calculations work perfectly in Discoverer 4.1.
Any help is appreciated.
Let me know if you require anymore information.