Cululative sum from Mindate to TillDate-5,4,3,2,1

[grajmca_sgp123]

Hi

I would like to show sum of values in lichart for last 5 days trend.

but my requirement is the sum of value should be from mindate to till date-5,date4-,date-3,date-2,date-1.

How can we achieve this pls provide your suggestions.some thing like attached

Thanks in advance

[sunny_talwar]

Would you be able to share some sample data with your expected output? It isn't very clear what you are trying to do.

Best,

Sunny

[grajmca_sgp123]

Thank you for your reply,

Here is the sample data

Input table:

Date	Value
7/14/2014	100
9/22/2014	80
10/12/2014	130
1/23/2015	150
4/22/2015	100
6/28/2015	120
8/10/2105	70
8/18/2015	50
8/19/2015	50
8/20/2015	300
8/21/2015	120
8/22/2015	140

I want to show line chart for last 5 days Cumulative sum.
X axis will have last 5  days dates
Output in line chart Values should be like below
Column1	Column2	(Cumilative value for all above dates)
8/18/2015	800
8/19/2015	850
8/20/2015	1150
8/21/2015	1270
8/22/2015	1410

Thanks

[sunny_talwar · Accepted solution]

This:

[sunny_talwar]

In a line graph: