Cummulative Data

[soniasweety]

Hi all,

I have small data I need cumulative sum of data in straight table.

I have attached excel with input data and output data please look into that.

[Anonymous]

do you like to separate it by year or not?!?

[soniasweety]

I need to separate  year also

[Anil_Babu_Samineni]

You may try like

Sum({<month = {">=getfieldselections(month) <=month(monthstart(max(year)))}>}sales)

-- Sent from iphone 7

[soniasweety]

can u attach sample qvw?

[Anonymous]

if you select april 2015, what do you expect as output?

[Anil_Babu_Samineni]

I  don't have system at this time, I may sent once I got chance to machine.

--  Sent  from iphone 7

[stabben23]

Try this first, this will gives you all the month you want: sum({<Month={"<=$(=Max(Month))"}>}Sales)

[soniasweety]

Hi,

If I select  aprl2014  in list boxes....  I need to get  output as

jan2014+ feb2104+mar2014 +aprl2014

[stabben23]

like this?