Value on monthbasis

[beck_bakytbek]

Hi Folks,

i got a Question: for example my data-environment does look like:

Month, Sales

1, 10

2, 20

3, 10

4, 50

i want to show my value in depence on month, i created the expression: Sum({<Month = {"<$(=max(Month))"}>}Sales) and it does work great: if i select all month untill Month 4 i see my whole amount: 90

but if select the Month: 2 until Month 4 i have still the amount: 90, the correct result should have : 80.

Does anybody have any idea how to resolve this issue by using set correct way of expression?

Thanks a lot

Beck

[Kashyap_R]

Hi 

Just use Sum(Sales) 

In your expression, it is taking the data till 4th month even though you select 2-4 months because you are using max(month) so it is giving 90

Hope this helps 

Thanks

[sunny_talwar]

Have you tried just using Sum(Sales)?