Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
How can I create a Sales Forecast chart (showing current sales (have data until 2011) and forecast of next year (say 2012) in my QV document. I have YearForecast and Sales as dimensions.
Help appreciated.
Thanks.
Hi Khaled
Use the time as your dimension, then you need to enter two expressions, one for the forecast, one for the actual sales.
EG dimension = month
expr1 = sum(Sales)
expr2 = sum(YearForecast)
is this what you need?
Regards,
Erica
Hi Khaled
Use the time as your dimension, then you need to enter two expressions, one for the forecast, one for the actual sales.
EG dimension = month
expr1 = sum(Sales)
expr2 = sum(YearForecast)
is this what you need?
Regards,
Erica
Thanks Erica. It worked.