Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Calculate Total and Percentage for BI Report
User_CWD7K
Rank 1 - Community Starter
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.
0
Answers
-
Do it in your query ...
0 -
what is your data source ?
0 -
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.
0