Skip to main content

Hi, I'd like to merge my Forecast and Actual data into a single table.
To do this, I created these metrics:
'IsActual Metric':


'Switchover date Metric':

'Growth Rate Hypothesis'

'PREVIOUS_(Month
)'


'FCST - Product': which should be my result. But the problem is that I get one result per Version, even though I need to have the 5-month Actual and 7-month Forecast data in the same table. Thank you very much for your help.

 

Hi,

 

do you have Data in Sales_by_product ?


Hi, 

Yes below. Thanks for your help 

 


You have all versions selected, could you select one ?

 

You can try to drill down on the empty cell and find where you data is BLANK