- 3,708,983 Users
- 2,241,169 Discussions
- 7,840,727 Comments
Forum Stats
Discussions
Categories
- 22 Industry Applications
- 3.2K Intelligent Advisor
- 4 Insurance
- 754 On-Premises Infrastructure
- 253 Analytics Software
- 22 Application Development Software
- 1.7K Cloud Platform
- 700.4K Database Software
- 17.4K Enterprise Manager
- 5 Hardware
- 110 Infrastructure Software
- 70 Integration
- 45 Security Software
How to set aggregate level for a member to Average in Planning

Hi ,
In the OEP_FS cube ,I have a member "WT Avg Contract Monthly Fee" under ACCOUNT dimension . There is another MARKET dimension is defined as MARKET->"WT Total"->" WT North"," WT South" ,"WT East"," WT West"
In the form , I need to show the average value(instead of addition) for "WT Avg Contract Monthly Fee" at the "WT Total " aggregation level .
In simple terms, if the value of "WT Avg Contract Monthly Fee" is 5 across each regions WT North, WT South,WT East,WT West , at the "WT Total" level , this needs to be 5 instead of 20.
How can this be achieved ? Screenshot attached for reference. Any inputs will be appreciated .
Thanks!