It's not clear why you're trying to create a waterfall chart - wouldn't a stacked bar chart do the same thing but simpler?
Hi Andrew - Yes , totally agree to your point on stacked bar graph . But business is keen to see the waterfall chart
After researching in forums I found where I was doing wrong . While doing a table calculation I had to set the option as "None" for the step 'restarting every'