0 Replies Latest reply: May 27, 2010 12:49 AM by Amirali Vastani RSS

    Pivot Table and Linear Trend Nature

    Amirali Vastani

      Is it possible to have the nature of the prior 3 months' linear trend either up, down or flat based on predefined limits put into a pivot table's expression as an image or text? I guess a positive slope (m) would mean trending up, and a negative slope (m) meaning trending down.

      I can load the image, but how to notate the nature of the trend which may be trending up, down or flat. What would that expression look like I wonder? I do run into pitfalls where a negative slope still results in trend going upwards. any mathematicians in the forum?

      anyone try something like this before?