how do i get the increase/decrease by year?

[#1]

Hello guys,

I have the next question:

I have a dimension year and the measurment sales. Now i want a table or graph or bargraph with the increase or decrease by year. Like this:

year	sales	increase/decrease sales compared to last year
2010	100
2011	200	100%
2012	150	-25%
2013	450	200%
2014	600	33%
2015	900	50%

How can i make this column and tihs table?

I hope somebody can help. thanks!

regards,

camiel

[swuehl · Accepted solution]

Dimension year

Then two expressions

=Sum(sales)

=Sum(sales)/above(Sum(sales))-1

[#3]

Hello swuehl,

Thank you!

Sometimes it's so simpel. But do you don't see what the solution is. i didn't knew about above.

[#4]

Hi Swuehl , I have same problem but small change in the dimension , I have Dimension Year-Quarter like 2015-Q1, 2015-Q2 ...

for this I would like to show the variance for 5 years in the bar chart, and I want to apply year, quarter filters also could you please guide me on this

[swuehl]

By accident Henric just wrote about Above() today:

The Above Function