Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have the following table:
Year | Value |
2000 | 100 |
2001 | 200 |
2002 | 150 |
2003 | 300 |
2004 | 450 |
2005 | 200 |
2006 | 130 |
2007 | 320 |
2008 | 300 |
2009 | 290 |
2010 | 150 |
2011 | 160 |
2012 | 170 |
2013 | 300 |
2014 | 400 |
2015 | 200 |
2016 | 170 |
2017 | 300 |
The user want to select one year: let say that the user will select 2017
I've been asked to to the following 2 analysis:
1. Straight table
year | Expresion1 | Expresion2 |
2013 | 300 | 630 |
2014 | 400 | 870 |
2015 | 200 | 900 |
2016 | 170 | 770 |
2017 | 300 | 670 |
This should display the last 5 year(based on user selection so in this case 2013-2017). The expresion definition are:
- expression 1 = sum(value)
- expression 2 = sum(value where year >= year -3 (last 3 years starting from year from dimension) EX: for 2017 i should display sum of values from 2015-2017, for 2013 sum of values from 2011-2013 etc
I've tried using rangesum but i didnt have any success.
2. Column Bar:
Here on the axes X to display only the year selected as label but on the column part to have all the year.
Anyone can point me to the right direction?
Regards,
Ionut
Like this?
yes, ty for that.
Do you happens to know some way to do the seconds request to?
This?
Perfect.
ty