Okay, I think visuals will help, this is the correct format:
\1

And this is what happens when I select a future month with no data for the pivot table to see:
\1