Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Dimension year
Then two expressions
=Sum(sales)
=Sum(sales)/above(Sum(sales))-1
Dimension year
Then two expressions
=Sum(sales)
=Sum(sales)/above(Sum(sales))-1
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.
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
By accident Henric just wrote about Above() today: