To show Relative Increment /decrement wrt to previous value.

[#1]

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.

year	sales
1990	100
1991	50
1992	200
1993	250
1994	300
1995	100

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.

[#2]

Hi Alka,

I have used (Current Year Sale - Last Year Sale)/Current Year Sale to give you a view that you want to see.

Hope the file attached helps.

Regards

RL

[#3]

Hi lakhina,

Thanks fr the helpful answer, but I had managed to solve it as it was required.

I had used" (sum(sales)-above(sum(sales)))/above(sum(sales)" and few design settings on graph.

This is providing me the required graph showing the percentage decrement and increment.( both + and -ve values plotted.)

🙂

[kamalqlik]

Hi Alka,

That will be shown as you will be having some negative value after the calculation will be made.

Regards

Kamal