This discussion is archived
0 Replies Latest reply: Jan 20, 2013 11:06 AM by 794701 RSS

sub - total and  Grand total Problem in discoverer Report

794701 Newbie
Currently Being Moderated
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..

Legend

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