6 Replies Latest reply: Feb 20, 2017 4:35 PM by Sébastien Fatoux

# Customer projection/trend

Hello everyone,

I have in a pivot table :

• my full time in 2016
• my full time in 2017 (until today)

How it's possible to add a projection for 2017 ?

Emmanuelle

• ###### Re: Customer projection/trend

Check same thing for your Data

Year,Value

2010,100

2011,200

2012,250

2013,150

2014,200

2015,120

2016, 140

2017,  ];

Dim -- Year

Expression:

if(Year<>'2017',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))

• ###### Re: Customer projection/trend

I have a global number who seems correct.

It's possible to have projection for each one of my clients ?

• ###### Re: Customer projection/trend

Yes, It is.

• ###### Re: Customer projection/trend

It does not work.

My pivot table brings back only one value and not a projection for each client.

• ###### Re: Customer projection/trend

Hi Emmanuelle,

An example with two customers A and B :

Year, Value, Customer
2010, 100, A
2011, 200, A
2012, 250, A
2013, 150, A
2014, 200, A
2015, 120, A
2016, 140, A
2017, , A
2010, 100, B
2011, 150, B
2012, 200, B
2013, 210, B
2014, 220, B
2015, 250, B
2016, 310, B
2017, , B
]
;

Dimensions :   Year, Customer

Expression :

if(Year<>'2017',sum(Value),
linest_m(TOTAL <Customer> aggr(if(sum(Value),sum(Value)),Year, Customer),Year)*Year
+
linest_b(TOTAL <Customer> aggr(if(sum(Value),sum(Value)),Year, Customer),Year)
)

If we add the linar approximation on the graph, we could see that the calculated point is just on it