Forum Discussion

lharrison's avatar
lharrison
Cloud Apps
04-04-2022
Solved

Year-To-Date for Only Completed Months

Hello, I have a pivot table where I am calculating YTD vs. LYTD metrics by month, like this: I want to exclude April from this table as it is not a completed month and thus doesn't provide u...
  • BobF's avatar
    04-05-2022

    Hello

    I would suggest adding a new custom column called, say, "YTD", set to "Y" or "N" based on whether the date/timestamp column you are using is the same year as today but not the same month as today

    Regards,

    Bob