Summary Calculate Total and Percentage for BI Report Content Hello Experts, I am looking to see how to calculate total and individual line item % based on the total. Would appreciate if you can provide any inputs for the same. * e.g. red part below is what I am looking to calculate. I am able to find the green part from a data set but running into issues with further % and total calculation. Comment Title Count Percentage Oracle ACS 5 50% Customer Daily 2 20% Oracle Global 2 20% Oracle Siebel 1 10% Total: 10 Attached is RTF file and Sample XML data.

Oracle Communities

Oracle Analytics and AI

Child Item

Home
Oracle Analytics and AI
Oracle Analytics and AI Forums
Oracle Analytics Forums
Oracle Analytics Forum

Calculate Total and Percentage for BI Report

User_CWD7K

Summary

Calculate Total and Percentage for BI Report

Content

Hello Experts,

I am looking to see how to calculate total and individual line item % based on the total. Would appreciate if you can provide any inputs for the same.

e.g. red part below is what I am looking to calculate. I am able to find the green part from a data set but running into issues with further % and total calculation.

Comment Title	Count	Percentage
Oracle ACS	5	50%
Customer Daily	2	20%
Oracle Global	2	20%
Oracle Siebel	1	10%

Total: 10

Attached is RTF file and Sample XML data.

Find more posts tagged with

Accepted answers

All comments

Thomas Dodds

Do it in your query ...

Venkat Thota - BIP

what is your data source ?

Jana Vakati

Hi,

Please find rtf and output here

better way is to calculating in query. if it is not possible

see the code in rtf

steps in breif.

1.declare variable

2.get sum of count (comment)

3.calc %

Hope this helps.