In this formel I am trying to cvhange the month at the end [January] to link to cell J6 -
Works
=GETPIVOTDATA("[Measures].[GWPremium]";'Name'!$A$16;"[Agent].[Main agent Hierarchy]";"[Agent].[Main agent Hierarchy].[Main agent].&[Name A/S]";"[Calendar Fiscal].[Calendar Fiscal (Year-Quarter-Month)]";"[Calendar Fiscal].[Calendar Fiscal (Year-Quarter-Month)].[Fiscal year].&[2019].&[1st Qtr].&[January]")
Tired:
=GETPIVOTDATA("[Measures].[GWPremium]";'Name'!$A$16;"[Agent].[Main agent Hierarchy]";"[Agent].[Main agent Hierarchy].[Main agent].&[Name A/S]";"[Calendar Fiscal].[Calendar Fiscal (Year-Quarter-Month)]";"[Calendar Fiscal].[Calendar Fiscal (Year-Quarter-Month)].[Fiscal year].&[2019].&[1st Qtr].&;J6")
=GETPIVOTDATA("[Measures].[GWPremium]";'Name'!$A$16;"[Agent].[Main agent Hierarchy]";"[Agent].[Main agent Hierarchy].[Main agent].&[Name A/S]";"[Calendar Fiscal].[Calendar Fiscal (Year-Quarter-Month)]";"[Calendar Fiscal].[Calendar Fiscal (Year-Quarter-Month)].[Fiscal year].&[2019].&[1st Qtr].&;"J6"")
=GETPIVOTDATA("[Measures].[GWPremium]";'Name'!$A$16;"[Agent].[Main agent Hierarchy]";"[Agent].[Main agent Hierarchy].[Main agent].&[Name A/S]";"[Calendar Fiscal].[Calendar Fiscal (Year-Quarter-Month)]";"[Calendar Fiscal].[Calendar Fiscal (Year-Quarter-Month)].[Fiscal year].&[2019].&[1st Qtr].&,;J6")
Bookmarks