1 Reply Latest reply: Dec 16, 2012 4:12 PM by Rod West RSS

    Displaying columns in Crosstab report.

    user533671
      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.
          Rod West
          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