0 Replies Latest reply: Feb 4, 2013 5:21 PM by 989091 RSS

    Discoverer 11g - How to get Sales Data in different periods?

    989091
      Good afternoon,

      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 11.1.1.3 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.

      My Conditions:

      Short Date Range = '2013' AND Month = 'FEBRUARY'

      My Calculations:

      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.

      Thanks,

      Andy Hoang