I'm trying to create a report with 14 columns.
Columns 1-12 are for the months of the year.
Column 13 is to be a YTD total.
Column 14, I want to display the average of the months I specify.
I've got Columns 13 and 14 working fine.
I'm a little confused about the formulas "-1M, -2M" and which columns to put them in. Since they are dynamic, how do I align them with columns designated for specific calendar months?
Is this correct? Do I need to adjust the report each month to keep the data aligned with the proper month? Is there a way to not have to adjust each month?
