In Excel Add-in, you can use the Splashing Wizard for Predict splashing. Note: a prediction as linear regression is only possible if multiple elements (calculation base) of exactly one dimension are specified. Also, the final value of the multiple elements (calculation base) must not be zero.
First, select the option “Copy/Like/Predict splashing”. Then select the option “Predict linear regression”.
Next, select multiple elements of exactly one dimension; in the screenshot above, 2012, 2013, 2014.
Click “Execute” to receive the predicted value for 2015 in the example above.