Hi,

I'm sorry for a poor title, I find it hard to describe my issue in a condensed way. So my issue is this:

I have a table that gets its information from several other tabs and pivottables. The formulas look like this:

=GETPIVOTDATA("[Measures].[Call]";'Data CD1'!$B$7;"[Call Day].[Call Month]";"[Call Day].[Call Month].[Call Month].&[2018-03]";"[Call Type].[Call Type]";"[Call Type].[Call Type].[Call Type].&[Answered]")

At the moment I need to go in to each formula and manually change the date (highlighted in red) for each new month. There has to be a better way so as I add a new row to the table the month automatically increases by 1. I would appreciate any help with this.