Sum of Rows vs. Expression Total

[jcampbell474]

I have a straight table where the row level numbers are correct, but the subtotal isn't.  I found several threads around this and it looks to be an aggregation issue, but can't get anything to work.

Can anyone help me understand what I'm doing wrong?

((avg(aggr(sum(SalaryxMin),UserId,cReportGroup, FiscalYearMonth ))*

((sum(HandleTimeSecs/60)) +(sum(aggr(sum(total <UserId,FiscalYearMonth,cReportGroup,Location> {<cReportGroup=,CS_Dept=>} AvailSecs)/60*sum(WorkGrpSecs)/sum(total <UserId,FiscalYearMonth,Location> {<cReportGroup=,CS_Dept=>} WorkGrpSecs),UserId,cReportGroup,FiscalYearMonth,Location))))))

TIA,

Jason

[sunny_talwar · Accepted solution]

Basically to sum the rows, you need to have an Sum(Aggr( YourExpression, YourDimension/s))

Sum of rows in pivot tables‌

Sum(Aggr(

((avg(aggr(sum(SalaryxMin),UserId,cReportGroup, FiscalYearMonth ))*

((sum(HandleTimeSecs/60)) +(sum(aggr(sum(total <UserId,FiscalYearMonth,cReportGroup,Location> {<cReportGroup=,CS_Dept=>} AvailSecs)/60*sum(WorkGrpSecs)/sum(total <UserId,FiscalYearMonth,Location> {<cReportGroup=,CS_Dept=>} WorkGrpSecs),UserId,cReportGroup,FiscalYearMonth,Location))))))

,YourDimensions))

[jcampbell474]

Ah, okay.  Perfect!

Thank you again, Sunny.  You make it look so easy!