(DELTE THIS THREAD PLOX) Getpivotdate ref error

[dramadeur]

I keep getting ref errors, no matter how I try to play with the function's parameters.
Here's a screenshot.
And the file itself.

As you can see, I'm trying to report the number of discharges per state, in the "States" sheet.

p.s. the problem was with the column names, turns out the "Total Discharges" have an excess space at the end of its name, and there are some other issues with names. So I simply renamed the columns in the "HospitalData" sheet, then recreated the table, and now it works!

[FDibbins]

Hi, welcome to the forum

Thanks for sharing the solution with us Trailing/leading spaces is a common cause of problems like that