Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Have you tried just using Sum(Sales)?