I need one part of the expression to be constant over the dimension

[#1]

I'm trying to create an expression in which there is a denominator that's supposed to be constant over the dimension. The dimension in my case is months and the part of the expression thats supposed to be constant is dependent on the first month. My goal is to create a graph which shows the value over a period of month realtive to the starting value.

How can I do this?

Right now I'm working with two expression that looks like:

sum(Market value)

and

sum({$<Period={$(StartMonth)}>} Market value)

The first expression gives me the market value for every month between the start month and the end month, and the second gives me the market value for the first month. But as I'm using Period as my dimension, the second expression only shows a value for the first month on the dimension axis. Can I structure the second expression shows the same value for all month on my dimension axis?

[sunny_talwar · Accepted solution]

Try this:

Sum(TOTAL {$<Period={$(StartMonth)}>} Market value)

[girirajsinh]

That's correct answer Sunny. It worked for me.

I hope Oskar finds the same.

[#4]

Yes, it works! Thank you!