topic Re: How to show cummulative data for a specific date? in Connectivity & Data Prep

How to show cummulative data for a specific date?

divyanshi — Thu, 06 Dec 2018 05:56:05 GMT

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 — Thu, 06 Dec 2018 07:01:40 GMT

Hi,

Not sure, but check below link if it helps.

Regards,

Kaushik Solanki

santhiqlik — Thu, 06 Dec 2018 10:36:24 GMT

Hi,

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