Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I would like to compare historical stock prices to an index.
All stocks and indexes are located in the same dimension: Bolagsdata.Bolagsnamn.
The price data is stored in another dimension: Closeprice.
In below graph the expression is simply "=Closeprice" , over a period dimension.
I want to display the index in the graph, which is "OMXS ALL GI" (see below list box), regardless of which stock that is selected.
Any thoughts on how to achieve this?
Thanks! The correct expression to use was the second part of your suggested expression:
Sum({
<Bolagsdata.Bolagsnamn={'OMXS ALL GI'}>}Closeprice)