Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Business Intelligence Foundation
This discussion is archived
on Feb 4, 2013 11:21 PM by 989091
Discoverer 11g - How to get Sales Data in different periods?
Feb 4, 2013 11: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.
I have the same question
Show 0 Likes
This content has been marked as final.
Show 0 replies