- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.1K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
How to set aggregation level to Average for a cross section in Planning
Hi All,There is a member in ACCOUNT dimension - "WT Avg Contract Monthly Fee"
There is a MARKET dimension which has MARKET(parent)->"WT Total Region"->"WT Total->"WT West","WT East","WT North","WT South"I need to bring in a cross section of data in a form wherein I need to display Average value of "WT Avg Contract Monthly Fee" at the "WT Total" level instead of sum.How to set the aggregation method as Average ?
In simple terms, if the value of "WT Avg Contract Monthly Fee" is 4 for each of the regions "WT West","WT East","WT North","WT South" at the "WT Total" level it should show 4 instead of 16.
Any inputs on how this be achieved ?