Hello..
I have been working on a data set creating an Forecast model. I will get the historical numbers from system and update in Col A to F post that J to O is the pivot linked. Starting from Col Q I have applied formula to calculate the forecast. When ever there is a new item Product or Sub Product added Col Q to T gets disturbs and I will to re work on complete data.
Is there any way that I can make it Dynamic as once the pivot is refreshed and new Sub products added still the function pick correctly along with the totals.
I have attached sample working file for reference.
Hope all are safe
Thank you
Bookmarks