calculation within a chart question

[alec1982]

hi all,

I have the following table

Store     year     Projected Amount

1          2015     1000

2         2016     1500

3         2017     800

4         2017     1200

5         2018     900

I need to build a bar chart of sum of future projected amount by year.. so 2015 will show everything in all years. 2016 will show the sum of 2016 and 2017 and 2017 will show only its value..doable?

Best,

Alec

[Kushal_Chawda]

P;ease see the attached