Please help!!!! :-)
I am struggling with a view (more on calculations) using a report which is generated in millions of cells (so cant do manual work) .... but I have below columns I need to use (just a summary):
|Forecast For All Months / FY||Actuals||Month||Month Report Generated|
Our forecast changes every month (dont ask!) and when the forecast is for the current month it is overwritten by the actuals (so in June/18 my actuals and forecast are same) and that is my major problem.. I need to compare actuals against all previous months but can only select them using the Month report was generated...so confusing!
so probably I need a paramenter to only filter forecast by the months selected while Actuals remain the same as FY (or YTD depending on what month we are) ... I am so brainless as I have been trying to work on smth for hours and nothing :-(
it would be fantastic if anyone could help me (Ps. I have not attached any workbook here coz data is sensitive)
THANKS HEAPS HEAPS HEAPS in advance!