Hi,
Please let me know if the below requirement is possible in OBIEE 11g and if so how do we achieve it
The subtotals apply the max( Facility Limit ) and the Grandtotals should apply the sum of the sub totals.
Customer
|
Facility No
|
Facility Limit
|
Morgan NY
|
3456
|
4000
|
Morgan London
|
3456
|
5000
|
Morgan Singapore
|
3456
|
75,000
|
Subtotal
|
|
75,000
|
|
|
|
Deustche Bank NY
|
5689
|
6800
|
Deustche Bank london
|
5689
|
45,000
|
Deustche Bank Singapore
|
5689
|
95,000
|
Subtotal
|
|
95,000
|
|
|
|
Grandtotal
|
|
170,000
|