Hi,
I'm having some problems trying to use Logest() function as a formula to a calculated field in my Pivot Table. The native fields of pivot table must be part of the array used as input to Logest formula. In normal tables i would simply use =logest(A1:D1). But when trying to create an array with pivot table fields, i.e. =logest({field1;field2;field3;field4}), it doesn't work. I get a syntax error.
How can I calculate the logest for each row in pivot table?
Every help is welcome.
Tnx Daniel
I'm having some problems trying to use Logest() function as a formula to a calculated field in my Pivot Table. The native fields of pivot table must be part of the array used as input to Logest formula. In normal tables i would simply use =logest(A1:D1). But when trying to create an array with pivot table fields, i.e. =logest({field1;field2;field3;field4}), it doesn't work. I get a syntax error.
How can I calculate the logest for each row in pivot table?
Every help is welcome.
Tnx Daniel
