Hi Gowtham, Ganapthi,
I created a bar chart (basis for waterfall) with the sum of the columns (column 1 + column 2 + column 3) per transaction ID.
Basically because you don't have negative values you don't exactly get a waterfall chart, but the script allows you to add the negative numbers, so add some data and you should be fine.
Community Example.qvw 154.5 K
This is the print screen
And this is the script I created
CROSSTABLE (Date,Numbers,2) LOAD
Transaction_No, Column 1, Column 2, Column 3, Week
1, 1, 1, 1, Week 51
2, 1, 0, 1, Week 51
3, 0, 1, 1, Week 51
SUM(Numbers) AS Numbers
GROUP BY Transaction_No,Week;
DROP TABLE temp01;