Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.)
🙂
Hi Alka,
That will be shown as you will be having some negative value after the calculation will be made.
Regards
Kamal