15 Replies Latest reply: Oct 30, 2014 4:44 PM by Jonathan Poole RSS

    "Trendline" in Pivot

      Hello,

       

      I have Pivot table as shown in attachment. It has two expressions =sum(TOT) (total sales so far) and =sum(BUD) (sales budget). Dimension on the top is months.

       

      1) Now I would like to have TOT sums for the rest of the months which are not ready on the basis of previous months. In the expression what I'm looking after is that I would count Full months sales so far divide by the amount of monts and the I would have sales per month which I could use in the total sales. This is accurate enough. In the chart I would also like to these numbers which are counted based on estimation to have another color so they would be noticed. One illustration is shown below.

      123456789101112Tot
      2323232322,442,442,4429,33

       

      2) And another newbie question is that I have total sums now on the right side Total TOT and BUD, how can I have another column on the end to have calculation  TOT minus BUD?