How to create calculation as a percentage of a row value
How do I create this calculation in OBIEE? It seems simple but I can't get the right results.
Let's say I have a field called Account with the following values:
Sales - 1000
Product Cost - 300
Operating Supplies - 100
Returns - 100
Fixed Costs - 300
I need to create a column that would be percentage of Sales. So my report would now show:
Sales - 100%
Product Cost - 30%
Operating Supplies - 10%
Returns - 10%
Fixed Costs - 30%
How do I do this? It's very easy for me to create a percentage of total calculation, but I can't create a percentage of a specific row.