Graphic Help

[#1]

Hi!

I'm trying to create a graphic of trend of costs in each year, where:

1. Total costs in 2011 is my reference line;

2. Y-axis shows percentage values from -100% to +100%, and total costs in 2011 value line starts from 0%;

3. On the total costs in 2012 line should be in evidence of the difference in percentage of total costs in 2011;

4. On the total costs in 2013 line should be in evidence of the difference in percentage of total costs in 2011;

Can you maybe help me with the example attached?

Thank you for any help ou can provide in this situation.

Regards,

Andrea

[#2]

Sorry, I have been too busy today to answer your message in time. I'd like to thank you very much for your patience and helpfulness, especially because I'm not so skilled about the matter!

I'm trying to create this graphic following your second option. Maybe it's a silly question...

If I add the calculated dimensions, the program dont recognize YY field. How should I do to set YY, without create a new field?

Is it possibile to bound YY data only to 2010/2011, 2011/2012 and 2012/2013. I dont want another value, even if there are others years in my data loaded.

Thank you for any help you can provide in this situation.

Regards,

Andrea

[jerem1234]

That is not a silly question, because that is entirely my mistake, I forgot to change the expression .

Used this as my dimension:

(year(addmonths(makedate(year,month),2))-1)& '/' & year(addmonths(makedate(year,month),2))

Then for expression:

(sum({<month= {1,2,3,11,12}>}cost)-

top(sum({<month= {1,2,3,11,12}>}cost)))

/top(sum({<month= {1,2,3,11,12}>}cost))

If you just want the first 3, then use dimension limits -> Show only -> First -> 3 values and un-check Show Others.

Of course this depends on if the first 3 values are the ones you want. If not, you may have to add more code to get there.

Please find attached.

Hope this helps!

[#4]

It was very kind of you to help me!

The expression creates these dimensions: 2009/2010, 2010/2011, 2011/2012, 2012/2013 and 2013/2014.

Using limit dimension First 3, I can't select the range from 2010/2011 to 2012/2013.

Could you suggest a solution, please?

I will be grateful if you can send me this information.

Andrea

[jerem1234]

Change your dimension to:

=if(match((year(addmonths(makedate(year,month),2))-1)& '/' & year(addmonths(makedate(year,month),2)), '2010/2011', '2011/2012', '2012/2013'),

(year(addmonths(makedate(year,month),2))-1)& '/' & year(addmonths(makedate(year,month),2)))

This is a rather cumbersome calculated dimension, so I am not sure how performance will be if you have a large data set. But this should get you what you want.

Hope this helps!

[#6]

I don't know how to thank you!!