Value for Max Month.

[coolwaters]

Hello,

i am trying to find a way to achive the following.

Have one bar chart with cyclic dimension, Year & Quarter.

Have two expressions, One for showing the total sales which is working fine.

Need help with the expression for closing stock. I have the closing stock for each month in the table.

If Year is selected as the dimension then the closing stock needs to be for the max month of that year.

If Quarter is selected then the closing stock needs to be for the max month of each quarter.

Can this be achieved via one expression.

Hope i am able to put forth my requirement clearly.

Thanks.

[jagan]

Hi

Use this expression

=Sum({<Month={'$(=Month(Max(DateFieldName)))'}>} ClosingStock)

Hope this helps you.

Regards,

Jagan.