How to display percentage contribution in Demand Management Cloud.
I would like to define a custom measure to display the % contribution of any region as compared to overall sales.
Contribution(%)= (Sales for a region/World wide Total Sales) *100
I have created a customer hierarchy and associated customer sites to specific regions.
I created a custom measure without Customer dimension and in measure expression included Shipments History. However, this is not showing working. (File: Custom Measure.doc)
Oracle DM provides capability to create a graph and shows percentage. However, I did not find any provision to display it on table.
Any help or pointer to achieve the requirement is welcome.