How to show cummulative data for a specific date?

[divyanshi]

Hi All,

I have a file which is updated every week ...and every week data is added to previous one .

I need to show cumulative data for a recent date in a pivot table corresponding to unit name .

I have the Date filter also Hence I need to show the cumulative data for every date depending upon the filter.

Kindly help.

I have already calculated cumulative data for all dates in a graph using 

Rangesum(Above(Sum(sales),0,[Date on which report is sent (week date)]))

But this will I need to show in pivot table also corresponding to unit name like A, B , C.

[kaushiknsolanki]

Hi,

Not sure, but check below link if it helps.

https://community.qlik.com/t5/QlikView-App-Development/Cumulative-sum-depends-on-dimension-values/td...

Regards,

Kaushik Solanki

[santhiqlik]

Hi,

In Pivot table, if the dates are in columns then you can use Before() in RangeSum.