1 Reply Latest reply: Feb 1, 2013 4:05 AM by Rod West RSS

    Total in Crosstab Report - Reg

    user533671
      Hi All,

      This is my crosstab report output.
                                 Category        c1       c2       c3      c4        total
                                                   Cost     Cost     Cost   Cost        
      Item       Qty     
      
      Item1       10                            100     50       40       10          200
      Item2       20                              50     40      100      10          200
      
      *Total                                      150     90       140     20          400*
      When i putting total it is coming column total and row total , it displaying only for cost. (c1, c2, c3, c4 are columns)

      I need total for Qty also. (10+20 = 30) also should come.

      Total                    30               150     90       140     20          400


      How to achieve this. Pl. help. I'm using Discoverer 10g.

      Thanks
      Kavi.