Aggregating total for reporting period excluding specific dimension.

[rnguyen2]

Hi below is an example where I want to show percentage of the AR Balance Total for Posting Period. I can only get it to populate for one row of the posting period.

Anyone know how I need to adjust the expressions?

Thank you.

[sunny_talwar · Accepted solution]

Try this

Sum([AR BALANCE])/
Aggr(NODISTINCT Sum([AR BALANCE]), [posting_date.autoCalendar.YearMonth])

[rnguyen2]

Thank you it worked!

[ahmetozmen]

Sum([AR BALANCE])/
Sum(total <[posting_date.autoCalendar.YearMonth]> [AR BALANCE])