I have data from 2016 and 2017. Right now I have a text box that shows March 2017 (but I have it from filters).
How can I create a formula that will show most recent month (complete) month in 2017 and then the same month for 2016.
Then I want the same thing but for YTD. I would like the user to be able to choose Month or YTD (vs prior YTD) and have that info show up.
I also would like to do the same thing, but subtract 3 months from the final month. Thanks.
Hi Alex could you please elaborate with an example.