Pivot Table Transpose with Cumulative in Qlik

[qlikview979]

Hi Experts,

How to do  Cumulative sum in pivot table with transpose level in qlik sense?

I can calculative cumulative sum in pivot table but,

Here my requirement is when i do transpose my cumulative expression is showing data is "zero".

for your reference i  attached snapshot.

INPUT:

T1:

Load * Inline [

ID,PRODUCT,SALES,MONTH

1,A,100,JAN2018

2,B,200,FEB2018

3,C,300,MAR2018

4,D,400,OCT2017

5,E,500,NOV2017

6,F,600,DEC2017

];

Expected O/P:-

Measures               Month

                                 Jan2018    Feb2018      Mar2018     Oct2017    Nov2017   Dec2017

Sales                          100             200              300              400            500           600

Cumulative sales        100            300              600              1000          1500           2100

Regards

Mahesh

[jyothish8807]

As per your inline table all field names are in ALL CAPS.

aggr(Rangesum(Above(Sum(SALES),0,rowno())),MONTH)

[Anil_Babu_Samineni]

Here we go ??

Update - QVW also attached? Because, Your forum is with Qlikview but your image is with Qliksense