Hi Sam, Yes, your understanding is correct. For more information. What I did are the following: (I have 3 years of data 2013 to 2015 with 3 columns date_column, Total Staff, Total Resign) First, I used date_column as Category, Total Staff as Measure, Total Resign as undelying factor is ignored and scenario analysis is disabled. Second, I tried to change the format of date_column I made it Year only, still Total Resign as undelying factor is ignored and scenario analysis is disabled. Third, (Data that not make sense). I tried to create a calculated item with this expression: DateFromMDY (Month (date_column), DayOfMonth(date_column), Parameter Year). Note: the value of Parameter Year is 2015. When I use this calculated item as Category. Total Resign as Underlying Factor accepted and scenario analysis enabled. but what happened to the data is that the data points are the sum of month each year. Example: For Jan2015 data point it shows the sum of (Jan2013, Jan2014 and Jan2015), For Feb2015 data point it's sum of (Feb2013, Feb2014 and Feb2015) and so on.. Fourth, I tried to retain the data for Jan to Dec 2015 only. date_column as Category, Total Staff as Measure and Total Resign as underlying factor. Yes, The Scenario analysis is now available. However, Everytime I set the target goal seeking I got this message "The values for the goal seeking targets could not be used because one or more data did not match the current forecast intervals." Fifth, I tried data for Jan to Dec 2014 only (the same with the fourth try) but Underlying Factor not accepted and Scenario Analysis is disabled. I just wondered, why the fourth and fifth try have the same format the only difference is the values but the underlying factor and scenario analysis for the fifth try is disabled. I don't understand how to trigger the scenari analysis. Thank you! Best Regards, Carrot
... View more