Forum Stats

  • 3,817,360 Users
  • 2,259,322 Discussions
  • 7,893,760 Comments

Discussions

Grand Total and Sub Total as % of Grand Total

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
This discussion has been closed.