Skip to Main Content

Grand Total and Sub Total as % of Grand Total

biswadasAug 6 2009
hi all,

we have a requirement where we need to achieve the following:

----------------------------------------------------------------------------------------------------------
Dim A | Fact A | Fact B | Grand Total
----------------------------------------------------------------------------------------------------------
X | 10 | 20 | 30 <-------- Line 1
----------------------------------------------------------------------------------------------------------
X1 | 10 | 20 | 30 <-------- Line 2
----------------------------------------------------------------------------------------------------------
Total | 20 | 40 | 60 <-------- Line 3
----------------------------------------------------------------------------------------------------------
Total as Percentage of Grand Total | 33% | 67% | 100% <-------- Line 4
----------------------------------------------------------------------------------------------------------


So we are okay till Line 3 and can be done easily in tabular view. It is the last row that is the cause of concern. I have found a roundabout way of doing it by creating union of three requests in BI Answers. But this is a complex solution and because we have drill down to other reports, it is simply gets more and more complicated. Because we are doing referential color coding we cannot use Pivot view, the report wont work unless it is in tabular view.

Any suggestion to work around this would be greatly appreciated.

Cheers,
Bis
Comments