rangesum problem...?

[#1]

I have the following data:

Year               Month           Sales

2013	1	1000
2013	2	2000
2013	3	3000
2013	4	4000
2013	5	5000
2013	6	6000
2013	7	7000
2013	8	8000
2013	9	9000
2013	10	10000
2013	11	11000
2013	12	12000

I need to select a month and the graph has to show the sales of that month + previous month

example:

if I choose month = 4

The graph should show: 7000

is that range sum or set-analysis?

[#2]

hi

try this

sum({$<Month={'>=$(=max(Month-1))<=$(=max(Month+1))'}>}Sales)

[tresesco]

You can do it both ways. If you have doubt, prepare a sample app and share. It would be easier to help you there. See how to prepare sample for uploading

[#4]

hi

sorry some mistakes in my above post

try this

=sum({$<Month={'>=$(=max(Month-1))<=$(=max(Month))'}>}Sales)

[#5]

hi

see attached file

[Sokkorn]

Hi,

Use this set analysis: =Sum({<Month = {">=$(=Max(Month)-1)<=$(=Max(Month))"} >} Sales)

Regards,

Sokkorn

[er_mohit]

Try this

Sum({<Month = {'>=$(=Max(Month)-1)<=$(=Max(Month))'} >} Sales)

[#8]

This one works! but in separate bars in the graph...
I need that the graph show the sum like if I choose month 4...the chart in one bar must show 7000...(4000+3000):

thanks

[#9]

Good Example, but I need like the green bar in the picture..

how could I do that?