0 Replies Latest reply: Jul 20, 2017 1:06 PM by Joshua Russin RSS

    Pivot Table - Current Month

    Joshua Russin

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

       

      table.PNG

       

      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.