This content has been marked as final. Show 3 replies
I am trying to achieve the following
|%ProductFamilyKey||Prov||Sales||% of Tot|
Sales = sum(sin_Sales)
How do I calculate the % Total based on the sub total for each %ProductFamilyKey
I have tried playing around with the aggr function with no success so far.
Any assistance greatly appreciated.