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.
Bookmarks