YTD Calculation in pivot table in qliksense

[Anonymous]

YTD should be calculated as per below in the attached qvf:

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6	Header 7	Header 8	Header 9	Header 10	Header 11	Header 12	Header 13	Header 14	Header 15	Header 16
Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 3,664 7,272 10,564 14,512 17,678 21,470 26,862 30,840 34,261 39,705 44,315 48,065 3,093 9,252 13,829 27,984 33,368 38,479 41,132 43,363 45,856 48,150 51,790 54,981 58,348 61,167 6,882 15,157 37 76 148 217 281 401 510 605 756 933 1,233 1,471 274 516 99 175 253 313 384 492 554 613 691 783 862 912 59 101 57 135 211 276 373 457 527 600 665 765 880 965 76 139 257 543 817 1,064 1,301 1,546 1,771 2,002 3,749 5,745 7,660 8,876 262 493 4 8 12 15 17 22 24 29 31 32 32 36

[sunny_talwar]

May be try this

If(SecondaryDimensionality() = 2, Sum(Aggr(RangeSum(Above(Sum(VALUEs), 0, RowNo())), Region, Country, Year, (Month, (NUMERIC)))), Sum(VALUEs))

Where Month and Year are created in the script like this

LOAD

    ID,

    Country,

    Date(CretaeDATE) as CretaeDATE,

   Year(CretaeDATE) as Year,

    Month(CretaeDATE) as Month,

    Region,

    VALUEs

FROM [lib://desktop/Data (1).xlsx]

(ooxml, embedded labels, table is Sheet1);