chart problem

[Anonymous]

hi

this is my problem:

i have a chart and i have to represent a value that is not in the cloud. it is external.

i find a solution using an expression and the " if " , but i would like to use a set analysis if it is possibile.

someone can help me?

i attach an example, my solution , very simple. i have the element year2 that is external and i use as dimension.

Regards.

[vgutkovsky · Accepted solution]

Alberto,

Actually, your IF is not working properly either. Here is the correct information:

year2	sum(price)
	127
2005	127
2006	127
2007	127
2008	127
2009	127
2010	127

The set analysis expression would be: sum({<year2=P(year)>}price) which does produce the correct results (a flat line over 2 of the years).

Cheers,