I am wondering how to adjust the aggregation of the values in 'Average of Available' while drilling up and down.
The first attachment is showing the data variation. The second attachment is showing that there are a lot of data points the same but for different dates.
The hierarchy goes Resource->Base->Date.
- Date level: straight-forward, it is 29 at each date, which shows on the graph.
- Base Level: I want the average of the 'available people' so I want it to show 29. Fine so far.
- Resource Level: I want all of the 'bases' to SUM together for each resource. Problem at this level.
How do I get the 'Average of Available' to get AVERAGE at one level and SUM at another level?