Help with GetPivotData formula

[pujo]

Made my first PivotTable.
I want to get data from the PivotTable into a cell on another sheet.
Using the GETPIVOTDATA function, I can retrieve data however...

This returns exactly what the formula says.

=(GETPIVOTDATA(" Products",ProductionPivot!$B$2,"Months",4,"Years",2023))

I want to retrieve data based on current month and year. (MONTH(TODAY()), YEAR(TODAY()) if possible.
How do I accomplish this?

Thanks!

 

[pujo]

Okay, I now have a better understanding.
If I create the formula in the same sheet as the pivot table, I get the results I am looking for.
Creating the formula on a different sheet with date cell references on that different sheet, I get the errors.

Thanks for your time and patience!

Pujo

 

[Alex Blakenburg]

Thanks for the update and glad we could help.

PS: The formula should work with the pivot on a different sheet though.

Below is what my resulting formula looked like with the Pivot on sheet "ProductionPivot"

20230502 Pivot GetPivot Formula pujo v02.xlsm
	F	G	H
1	Input
2	Month	5
3	Year	2023
4
5	Result 1	23800	=GETPIVOTDATA("Products",ProductionPivot!$B$2,"Months",$G$2,"Years",$G$3)
6	Result 2	23800	=GETPIVOTDATA("Products",ProductionPivot!$B$2,"Months",MONTH(TODAY()),"Years",YEAR(TODAY()))
7	With error handling	23800	=IFERROR(GETPIVOTDATA("Products",ProductionPivot!$B$2,"Months",$G$2,"Years",$G$3),"")
Sheet1

Cell Formulas
Range	Formula
G2	G2	=MONTH(TODAY())
G3	G3	=YEAR(TODAY())
G5	G5	=GETPIVOTDATA("Products",ProductionPivot!$B$2,"Months",$G$2,"Years",$G$3)
H5:H7	H5	=FORMULATEXT(G5)
G6	G6	=GETPIVOTDATA("Products",ProductionPivot!$B$2,"Months",MONTH(TODAY()),"Years",YEAR(TODAY()))
G7	G7	=IFERROR(GETPIVOTDATA("Products",ProductionPivot!$B$2,"Months",$G$2,"Years",$G$3),"")