4 Replies Latest reply: Nov 30, 2012 4:03 AM by Dmitry Lapchenkov

# sum selected and some unselected

Hi!

I have simple table with fields:

CountrymonthSale
England20120114 625
England20120218 733
England20120324 169
England20120422 171
England20120522 586
England20120625 032
England20120728 343
England20120824 971
England20120925 826
England20121024 560
England20121115 207

and i want add object like this:

CountrymonthSale
England201211= sum of last 3 month

problem is - when i select 201211 another monthes just disappear from my sum.

is anybody know what i missed?

• ###### Re: sum selected and some unselected

Hello,

Change your expression to =Sum({<Month =, here the set analysis what you develped to get last 3 months>}Sales)

• ###### Re: sum selected and some unselected

Hi, Jagan Nalla!

Im only in step - getting month that = moth-3

if(Right(month,2)>3,month - 3,left(month,4)-1&12+(Right(month,2) - 3))

i have:

 Country month Sum (Sale) 3month England 201201 14625 201110 England 201202 18733 201111 England 201203 24169 201112 England 201204 22171 201201 England 201205 22586 201202 England 201206 25032 201203 England 201207 28343 201204 England 201208 24971 201205 England 201209 25826 201206 England 201210 24560 201207 England 201211 15207 201208

exemp. last row:  my month is 201211 and 3month ago is 201208

and now i need formula, that sum all sales between 201208 and 201211

in spite of: selected those data or not

• ###### Re: sum selected and some unselected

You can do this by joining every month with the months of its three month period and sales for those months. See attached example.

• ###### Re: sum selected and some unselected

Hi, Gysbert!

How can i do this joining? Only when i load data?

incoming data sourse has more than 900 000 rows