Pivot Table - Show Current Month

[joshrussin]

Trying to figure out how to make this pivot table work correctly.

I am trying to get ONLY the days in the CURRENT month in this pivot table. Any ideas?

Right now I have a column = Date

I have tried setting the column = {$<Month_RD = {"$(=Month(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"},  Year_RD = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"}>}Date

But it says that is invalid.

[joshrussin]

Thanks! Works perfectly now!

[joshrussin]

Now I have another question for ya.

I have put the same equation in a line graph and am getting a random number hanging on the end after all of the correct dates are displayed. any clue how to get rid of this?

[joshrussin]

Never mind, I just unchecked the null value option. Works perfectly.