Need help for a Logic

[Anonymous]

Hi,

I have a requirement which is little tricky.

I have to calculate a value (Sum(Sale))for the first month (January) of the calendar year and then populate the same value (calculated for Jan) for the rest of the year in a chart (Month as dimension) . Can someone please help me in how to do that?

Example for Jan it is 300, then for Feb to Dec it is 300 and show it in a chart. Month as dimension and the sum(sale) which is 300 as expression. How can we do this?

Thanks.

[swuehl · Accepted solution]

Maybe use Month as dimension and

=Sum({<Month = {'Jan'}>} TOTAL sale)

as expression

[Anonymous]

Thank you so much Stefan. That worked