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
.