This discussion is archived
1 Reply Latest reply: Dec 16, 2012 2:12 PM by RodWest RSS

Displaying columns in Crosstab report.

user533671 Newbie
Currently Being Moderated
Hi all,

I have developed Matrix Report. Output is coming like below.
 
                                                                                  
                                                                                                       
                                                  
                                                                                                      Current Vol                   OPM Cost
                                   Category     X1   x2   x3    x4       x1     x2      x3      x4
                               -------------------------------------------------------------------------------------------
Product  Market                            
AAA1     Japan                                10  20    30    40       10      20     30     40
BBB1     Japan                                10  20    30    40       10      20     30     40
Current volume also displaying based on category. But, i need to display as Current vol one time only. instead of 4 (X1,x2,x3,x4). OPM cost should display as matrix based on category.
Please let me know , Is it possible to do it in Discoverer.

Thanks
Kavi
  • 1. Re: Displaying columns in Crosstab report.
    RodWest Guru
    Currently Being Moderated
    Hi,

    Yes it is possible but you will need to have each category as a separate row then use a crosstab report to display the rows in a matrix.

    To create the extra rows for each catogory you will need a row generator in your EUL. See this link http://learndiscoverer.blogspot.com/2008/10/row-generators.html for details.

    You can then use decode to define the calculation that will display the OPM cost for the category on the row.

    Rod West

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points