Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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,
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,