Hi all,
I currently have a straight table that displays an overall weighted avg at the bottom due to total mode being enabled. I need to modify the expression so that that overall weighted avg (3.00) shows on each row, not just the last one as a total.
Below is the expression I'm currently using and a screenshot of the table:
=if(num(ReportDate) < '43312',
SUM(Aggr(
IF($(RoundedRate%)>=num#(PtileBeg) and $(RoundedRate%)<= num#(PtileEnd)
,Star) * Only(RptCardWeight)
,Star,_MeasureYearKey,PCP_ID))
/
SUM( RptCardWeight),
round(SUM(Aggr(
IF($(RoundedRate%)>=num#(PtileBeg) and $(RoundedRate%)<= num#(PtileEnd)
,Star) * Only(RptCardWeight)
,Star,_MeasureYearKey,PCP_ID))
/
SUM( RptCardWeight) ,0.1))
Any help is much appreciated!!
Never mind I think I just got it 
=round(SUM(TOTAL(Aggr(
IF($(RoundedRate%)>=num#(PtileBeg) and $(RoundedRate%)<= num#(PtileEnd)
,Star) * Only(RptCardWeight)
,Star,_MeasureYearKey,PCP_ID)))
/
SUM( TOTAL(RptCardWeight)) ,0.1)
