Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Next example
First column year with totals pro week for years 2014 and 2013
2014 2013
52 100 150
51 200 200
50 300 600
49 400 350
Now i want to add 2 columns pro year.
First column shows me the difference amount. Column next to it shows me the percentage growth / lost toward previous year.
2014 2013
52 100 -50 33,33% 150
51 200 +0 0% 200
50 300 -300 -50% 600
49 400 +50 14% 350
How to do this?
Hi,
Find attached.
HTH
sushil
Hi,
Can't find attachment
Attention to Orginal Question
Who helps me?
Thx in forward.
Hello,
Big Challenge. Does nobody knows the answer?
Attached is the solution
Ivelin
Thx, but excuses me I am new.
I do not know what you mean. can you explain me more?
Thx in advance
Hello,
Who can help me and explain how attaced is being used?
Hi,
I will Explain You abou the attached file above.
1 ) For Getting 2013 Sales the expression is : Sum({<Year = {'2013'}>} totals)
2 ) For Getting 2014 Sales the expression is :Sum({<Year = {'2014'}>} totals)
Then you Want 3 Expression in the Difference
3 ) Add Expression and Name it Difference : Sum({<Year = {'2014'}>} totals) - Sum({<Year = {'2013'}>} totals) - Use this Expression.
Then you Want 4 Expression in the Difference in Percentage
Use This Expression : (Sum({<Year = {'2014'}>} totals) - Sum({<Year = {'2013'}>} totals))/ Sum({<Year = {'2013'}>} totals)
Hope you understand this.
Regards
Suresh Rawat
thx! But instead of Year i have to take yearweeknr?! I shall try this later.