How to calculate Cumulative total

[#1]

I have attached the sample Qvw and the test file and I have to calculate the cumulative total.Can some one please help me here ?

I am having very hard time figuring it out.Thanks.

I have explained my requirement further in the qvw.

[Clever_Anjos]

Use this technique: The As-Of Table

[sunny_talwar · Accepted solution]

Expanding your idea in the following example.

Script added:

LinkTable:

LOAD DISTINCT MonthYear as ReportYear,

  Date(If(AddMonths(MonthStart(YearEnd(MonthYear)), IterNo() - 12) <= MonthYear, AddMonths(MonthStart(YearEnd(MonthYear)), IterNo() - 12)), 'MMM-YY') as MonthYear,

  If(AddMonths(YearStart(MonthYear), IterNo() - 1) = MonthYear, 1) as Flag

Resident ProjectPipeline

While IterNo() <= 12;

Dim:

LOAD * Inline [

Dim

1

2

3

];

[#4]

syou are the best stalwar1‌Thanks much,...appreciate your kindness and time !!

[#5]

Hi Sunny,  stalwar1‌

In this Cumulative total I am havinng an issue as my data file updated and additional months got added including 2017 months..so Total cumuulative is only adding up until Dec 16 .I want that to add on until all the existing months.How can I do that ?Any help is appreciated.

I have attached the sample file and the QVW.THANKS MUCH again.

[#6]

stalwar1‌ sorry to bother you.Any help is appreciated.Thanks much.

[sunny_talwar]

Check now:

ProjectPipeline:

LOAD

    Area,

    PPRegion,

    Market,

    Date(Date#(Trim(SubField(Header, Chr(10), 1)), 'MMM-YY'), 'MMM-YY') as MonthYear,

    Header as Header2,

    SubField(Header, Chr(10), 2) as Header,

    Value

Resident Table;

Left Join (ProjectPipeline)

LOAD Min(MonthYear) as Min_MonthYear

Resident ProjectPipeline;

DROP Table Table;

LinkTable:

LOAD DISTINCT MonthYear as ReportYear,

  Date(AddMonths(MonthYear, IterNo() - ((Year(MonthYear) * 12 + Month(MonthYear)) - (Year(Min_MonthYear) * 12 + Month(Min_MonthYear)))), 'MMM-YY') as MonthYear,

  If(AddMonths(MonthYear, IterNo() - ((Year(MonthYear) * 12 + Month(MonthYear)) - (Year(Min_MonthYear) * 12 + Month(Min_MonthYear)))) = MonthYear, 1) as Flag

Resident ProjectPipeline

While IterNo() <= ((Year(MonthYear) * 12 + Month(MonthYear)) - (Year(Min_MonthYear) * 12 + Month(Min_MonthYear)));