Hello Gurus,
I am trying to divide the Totals at region level with Profit Center Level. For
Produced MH % = Profit center Volume / Region Total Volume
For example - Produced MH % = 450 / ( 450 + 1050 ) = 450 / 1500 = 0.30 for Jan Month.
I am applying formula = Volume Per month Total GUM / SUMGT ( Volume Per Month Total GUM )
Above formula is working correct if User Selects One Region MXN1, But If user selects More than One Region, SUMGT is add all regions and dividing based on the formula....
I tried Aggregation by Region and Calculation, but no luck.
Please any once can share how to resolve if user enters more than one region in the selection.
Thanks
Ganesh Reddy.