Hi,
I have a pivot table with the following info:
Month 2016 2017 2018
Jan 40 17 93
Feb 45 35 63
etc.
I want to make a calculated field to add a forecast column. The formula would be the standard forecast.ets formula and needs 2019 as the target date, the values are the row data (40, 17, 93 in this sample), the timeline would be the years (2016, 2017, 2018). I don't know how to do this with a calculated field or even if it can be done. I tried doing it outside the pivot table but got a #div/0! error because of the dates (I think). The added column would look like:
2019 ETS
107 and so on for each row
Any help would be greatly appreciated
Thanks so much!
Jeremy
Bookmarks