I am trying to display the planned hours by quarter against available hours where the available hours are based on (40 hour week x 52 weeks)/4 = 520. We then take that number and lookup the resource count by Team and multiply the 520 by that. Additionally, since team members work on things other than audits, there is a factor assigned by team that is used as a final multiplier as shown in the above data chart.
The issue is that in the bar graph, I need to calculate the time available by aggregating the product of all these factors based on team and any filters that might be set limiting which team we are looking at,
The expression I wrote which is not working is: =Aggr(Sum(Sum(QtrWorkHours)*RscCnt*Factor),Team) as well as =Aggr(Sum(QtrWorkHours*RscCnt*Factor),QtrWorkHours,Team).
The Planned Hours bar chart expression is just: Sum(PlannedHrs)