Forecast

[#1]

Hi every one ,

I have a excel like below, i want a bar chart that show sale amount for exist year and show forecast sales for 2016(next year) ,

which function i can do ?

please help me ?

Best Regards

Hamide

[Anil_Babu_Samineni]

Above(Sum(Sales))

[#3]

Thanks for your reply , but it's not my answer .

i write below expression :

     if(sum(Sale),sum(Sale)

     ,linest_m(total aggr(if(sum(Sale),sum(Sale)),Year),Year)*Year

     +linest_b(total aggr(if(sum(Sale),sum(Sale)),Year),Year))

but my expression doesn't  show sales amount for 2016

[Anil_Babu_Samineni]

Can you please post small Application

[Kushal_Chawda · Accepted solution]

You need to have Year 2016 in data

LOAD * Inline [

Year,Value

2010,100

2011,200

2012,250

2013,150

2014,200

2015,120

2016 ];

Expression:

=if(Year<>'2016',sum(Value),

    linest_m(total aggr(if(sum(Value),sum(Value)),Year),Year)*Year

    +linest_b(total aggr(if(sum(Value),sum(Value)),Year),Year))

[#6]

Thanks Kushal,

For static data like load inline it is ok but for dynamic data which solution you offer,

My document is connected to sql server and i haven't next year in my data.

Regards

Hamide

[Kushal_Chawda]

You can manually add Year like below

YourData:

LOAD  Year,

...

FROM Table;

concatenate(YourData)

LOAD * inline [

Year

2016 ];