3 Replies Latest reply: Oct 11, 2012 5:54 AM by Kamal Naithani RSS

    To show Relative Increment /decrement wrt to previous value.

      Hi Everyone,

       

      I m stuck with a problem to show relative increment and decrement of sales wen compared to previous year.

       

      I have a table consisting 2 fields showing Year & sales values eg.

       

      yearsales
      1990100
      199150
      1992200
      1993250
      1994300
      1995100

       

      I am required to make a table or a chart( preferably chart) that must show values of  percentage increase or decrease in sales wen compared to just previous year starting frm 1991.

      the prob is dat even thogh i have found out the corresponding values of inc/decr.using "  =sum(sales)/above ( total sum(sales)))* 100  "   but i have to show them in percentage inc /dec. ie, the decreasing amount should show -sign .Ii am stuck with, how to show the sign of decremented value

       

      Is there any such method to show this in  a graph?? ..orr any method to plot negative values in graph..??.or atlest to show the result value with % sign alongwith.

       

      thankx fr all generous response in advance.