Weighted average in Total Row in a pivot table

[phoenix]

Is there a way to replace the sum in Total row with this weighted average calculation? Thanks

[sunny_talwar]

May be this

If(Dimensionality() = 1, Sum(AAA*HHH)/Sum(HHH), Sum(AAA))

[phoenix]

stalwar1‌ can you take a look at the app? trying to get the logic work in this example. Thanks

[Sergey_Shuklin]

Hello!

You can use special calculating condition IF RowNo() = 0.

[sunny_talwar · Accepted solution]

Try this

If(Dimensionality() = 1,

Sum(AVG_BAL * If(Mod(RPT_PRD_DATE_YR, 4) = 0 and Mod(RPT_PRD_DATE_YR, 100) <> 0, 366, 365)/RPT_DAYS)/Sum(Aggr(Only(If(Mod(RPT_PRD_DATE_YR, 4) = 0 AND Mod(RPT_PRD_DATE_YR, 100) <> 0, 366, 365)/RPT_DAYS), RPT_DATE_YR, RPT_DATE_MTH)),

Sum(AVG_BAL))

[phoenix]

Thanks stalwar1‌ that worked