lharrison
04-04-2022Cloud Apps
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 useful information. I can't figure out how to do that from the filters pane and haven't had any luck with scripts either. Does anyone have any ideas?
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