Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Business Intelligence Foundation
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Feb 4, 2013 5:21 PM by
Discoverer 11g - How to get Sales Data in different periods?
Feb 4, 2013 5:21 PM
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 220.127.116.11 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.
This content has been marked as final.
Show 0 replies