tricky question?

[Anonymous]

Hi ,

i have data for jan 2013 sales is 100  and dec 2013 sales is 1200 , remining  feb,mar,....oct,nov i dont have

but my req is

i want see the data for 

jan is 100

feb is 100

mar is   200(jan+feb)

apr is   400(jan +feb+mar)

like this i want till dec(jan+....+dec)  .

i have to do this in script level only not in chart level using accumulation.

how ?

[MK_QSL]

Sales:

Load

  Date#(Month,'MMM') as Month,

  Sales

Inline

[

  Month, Sales

  Jan, 100

  Feb, 200

  Dec, 300

];

Join

Load  

  Date#(Month,'MMM') as Month

Inline

[

  Month

  Jan

  Feb

  Mar

  Apr

  May

  Jun

  Jul

  Aug

  Sep

  Oct

  Nov

  Dec

];

Final:

Load

  Month,

  Sales,

  RangeSum(Peek('TotalSales'),Sales) as TotalSales

Resident Sales

Order By Month;

DROP Table Sales;