Calculate revenue % distribution for each project with in Business unit
Summary:
We have the below requirement
Project1 Revenue amount-20
project2 Revenue amount-30
project3 revenue amount-16
Total BU revenue amount 66 (this is achieved by enabling totals)
Project1 revenue % with respect to total is (20*100)/66=30.3%
Project2 revenue % with respect to total is (30*100)/66=45.5%
Project3 revenue % with respect to total is (16*100)/66=24.2%
Please let me know how to calculate % in OTBI reports based on the totals generated?
Content (required):
Version (include the version you are using, if applicable):
23B
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0