Year total in Monthly Denominator

[carlcimino]

Hello, I have a situation where I need the Year total to be the denominator for every month and Quarter but also for the year.  I've been struggling with the set analysis required to do this.  3.8% is the correct number for the year total but I need the months to add up to 3.8%.  Any help would be appreciated.

This got me close but it only put the desired amount in January and the Total.  With nothing in Feb-Dec.

sum(aggr(sum({<DATA_TYPE={'STAT'}>}STATUTORY_WRITTEN_PREMIUM),Year))

[carlcimino · Accepted solution]

Should have been using the total command in my set analysis instead of Aggr().

sum(total<Year>{<DATA_TYPE={'STAT'}>}STATUTORY_WRITTEN_PREMIUM)