How can I add a metric aggregated only by one dimension in a two-dimensional pivot table?

[hotui5mmlh05lnl]

I have a pivot table with two dimensions: POLICY_TYPE and PERIOD.autoCalendar.Year.

I would like to sum, grouping only by PERIOD.autoCalendar.Year.

How do I do it?

I have tried to do:
sum( aggr( sum({<PROGRAM = {'MVS'}>} NET_NEW_POLICIES), [PERIOD.autoCalendar.Year]))

But the total value accumulates only in one of the columns instead of in all, I need that value that appears in column "1" to appear in all columns.

Thank you

[hic · Accepted solution]

Try

sum( total <[PERIOD.autoCalendar.Year]> NET_NEW_POLICIES )