Skip to Content
0
Jun 08, 2009 at 01:32 PM

Subtotal are right but overalltotal on Orgs is not coming right ( BPC 5.0)

27 Views

All,

We have build up report which is summing up some number based on org , which is working fine but it is not showing over total in 1 row as explained below on one org . As we have multiple org under a big org . I have to report each org population and at the end I have to report overall total for that org . Overall total is not coming instead of overall total , BPC excel is repeat total for each org e.g

   ORG A00001  (total)                                     30    37    0        1     68         
 Org A000002    (total)                                        3     4     0        0     7          
I ned  overall total as 
*Total  Org A00001   (Over All Total)                        33    41    0        1     75*   
Org A000001
   Fixed-a                                                                                
Fixed-b                                                       29    34             1     64         
      Fixed-c                                                                  2                    2          
      Fixed-d                                                        1     1                    2                                                                                
ORG A00001  (total)                                     30    37    0        1     68                                                                                
Org A000002
     Fix-r                                                                 3     4                    7                                                                                
Org A000002    (total)                                           3     4     0        0     7          
    	             
Total  Org A00001   (Over All Total)                        33    41    0        1     75                                                                                

Thanks.

Saquib

.