Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Percentage in Bi

arsalan.dilawar@hotmail.comJan 11 2010 — edited Jan 11 2010

Asalam mo alikum...

I am very much new to Bi.. thts why i am having some problems in bi... Now latest issue is
that
i have created a report by using pivot table.. but problem is that now i want to take out percentages of every asset per region.... *(SOUTH , NORTH , CENTRAL are my regions)*

Now this is current view of my report
---------------------------------------------------------------------------------------------------------------------------------------------
Assets South North Central Total Assets
---------------------------------------------------------------------------------------------------------------------------------------------

abc 100 200 150 450
xyz 200 100 50 350

Total 300 300 200 800

Now i have to take out percentages of every asset per region (SOUTH,NORTH,CENTRAL are my regions) out of sum Total of region For example...

----------------------------------------------------------------------------------------------------------------------------------------------------------
Assets South North Central Total Assets South North Central Total
----------------------------------------------------------------------------------------------------------------------------------------------------------

abc 100 200 150 450 33.3% 66% 75% 57%
xyz 200 100 50 350 66% 33% 25% 43%

Total 300 300 200 800

Now is this possible in Bi publisher or through sql Query ????

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 8 2010

Added on Jan 11 2010

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

6 comments

1,963 views