Yodelayheewho
Member
Hello,
I'm not able to find the solution to the following formula. I keep getting a #REF! error.
=GETPIVOTDATA("Sum of Actual",'PIVOT-SP'!$A$3,"QTR Ends",DATE(YEAR($D$2),((INT((MONTH($D$2)-1)/3)+1)*3)+1,1)-1,"Budget Category","General")
If I remove field2 and item2 ("Budget Category","General"), like this:
=GETPIVOTDATA("Sum of Actual",'PIVOT-SP'!$A$3,"QTR Ends",DATE(YEAR($D$2),((INT((MONTH($D$2)-1)/3)+1)*3)+1,1)-1)
I remove all proprietary information and uploaded a file here as an example.
Thank you in advance!
I'm not able to find the solution to the following formula. I keep getting a #REF! error.
=GETPIVOTDATA("Sum of Actual",'PIVOT-SP'!$A$3,"QTR Ends",DATE(YEAR($D$2),((INT((MONTH($D$2)-1)/3)+1)*3)+1,1)-1,"Budget Category","General")
If I remove field2 and item2 ("Budget Category","General"), like this:
=GETPIVOTDATA("Sum of Actual",'PIVOT-SP'!$A$3,"QTR Ends",DATE(YEAR($D$2),((INT((MONTH($D$2)-1)/3)+1)*3)+1,1)-1)
I remove all proprietary information and uploaded a file here as an example.
Thank you in advance!