0 Replies Latest reply: Jan 20, 2013 1:06 PM by user4929345 RSS

    sub - total and  Grand total Problem in discoverer Report

    user4929345
      Dear All,

      One of my discoverer desktop report layout is as :

      Band     SALES     A     B     C
      1     1200     100     100     100
           1200     100     100     100
           Sub-Total:2400               
                          
      2     2400 100     100     100      
           2400     200     100 100
           2400     200     100     100
           Sub-Total:7200               
                          
           Grand Total: 9600               

      a. Calculating sub-total of sales column based on Band column and then grand total at bottom
      b. Here sub-total and grand-total is coming wrong ,
      it should be
      a. Sub-total : distinct values of Sum bases on Band Column i.e. 1200
      b. Grand_total : 3600 i.e. Sum of distinct values of Sum bases on Band Column.


      I want output should be :


      Band     SALES     A     B     C
      1     1200     100     100     100
                100     100     100
           Sub-Total:1200               
                          
      2     2400 100     100     100      
                200     100 100
                200     100     100
           Sub-Total:2400               
                          
           Grand Total: 3600               


      I tired this using group sorting on sales column but then sub-total and grand total calculation is coming wrong.

      Any suggestion..?

      Thanks in Advance..

      Thanks..