Multiple Periodicities

Is it possible to have a dynamically adjsuted summary report by years for a monthly model?

I guess it's doable if to set up a strucutre with a required numbers at the year end and group and hide other months columns in all years but are there any other ways?

Or simple VBA code to adjust it would be a best solution?

I have a monthly budgeting model and want to input some assumptions on an annual basis but I get an error message when I try to insert annual modules. How can I add an additional time series to my model? I used to be able to do this in toolbox but I can't seem to work it out with the new software. Thanks in advance, Channing

See Image Below: